Need an Alternative to "Rank" function

Originally Posted by RichardSchollar

RANK is basically just a representation of COUNTIF, so you can use that instead (which I believe is available, according to that website). So in C1:

=COUNTIF($B$1:$B$5,"<"&B1)+1

copied down.

Hope this helps!

Richard

Thats excellant Richard, it covers the Rank, the Small (first row onwards) and the Large = last row (working up)

---

Hi,

I thought of that but he can't use Countif either looking at the list of functions available to him

VBA Noob

Originally Posted by VBA Noob

Hi,

I thought of that but he can't use Countif either looking at the list of functions available to him

VBA Noob

HI,

countif is listed on that site:

COUNTIF(range, criteria) Counts the number of non-blank cells within a range that meet the given criteria Math & Trig.

---