Need an Alternative to "Rank" function

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.

---