Ranking

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
Back
Top