Works great so far. Now what if I want to rank from lowest to highest?
Meaning lowest number is "number 1".

Ardus Petus wrote:
=IF(ISNA(RANK(A1,A$1:A$20)),"",RANK(A1,A$1:A$20 ))

HTH
--
AP

I am creating a ranking sheet with 20 rows. There will be a differing amount
of numbers to rank. Sometimes there may only be 10 numbers to rank and
sometimes more or less. How do you prevent the blank spaces from being part
of your ranking? In other words, if I have 10 numbers, I want to rank 1
through 10 and ignore the spaces 11 through 20.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200604/1