Ranking

[Guest]

I need some assistance ranking a set of numbers. Here is the help screen
that Microsoft provides.

A
Data
1 7
2 3.5
3 3.5
4 1
5 2


Formula Description (Result)
=RANK(A3,A2:A6,1) Rank of 3.5 in the list above (3)
=RANK(A2,A2:A6,1) Rank of 7 in the list above (5)


This works great if I want to rank cell A1 #5. What is the formula is I
want cell A1 (the highest) to be ranked #1?

Thanks in advance for your help.

Regards,

Cory

 

[Guest]

Never mind, I think I just figured it out. For those that are wondering, it
appears to me that the formula should be:

=RANK(A2,A2:A6,0) Rank of 7 in the list above (1)

This appears to work. If this is not correct, please let me know.

Regards,

Cory

 

[Pete_UK]

Yes, that is correct, although you will probably want to make it:

=RANK(A2,A$2:A$6,0)

if you want to copy it down.

You could also look at the LARGE and SMALL functions.

Hope this helps.

Pete