How would it work if I needed the rank in a range of numbers, lets say
between 550 and 855?

"Stephen" wrote:

With your numbers in A1:A4, put this formula in B1 and copy down as far as
B4:
=IF(A1550,RANK(A1,$A$1:$A$4),"")
Is this what you want?

"David A." wrote in message
...
I need to know how to rank a list of numbers but only rank the numbers
above
550.
Example
A
1523
1242
550
890

I need to rank 1523, 1242, 890, and leave 550 out...
So the ranking should be 1523:3, 1242:2, and 890:1
Thanx.