How can I rank a group of values?


Posted by Chris Rock on September 18, 2001 7:10 PM

Column F has some values calculated every 6th row. I would like to, in another column, put the "ranking" of each of those values.

For instance:
F1 - 900
F7 - 500
F13 - 200
F19 - 1000
F25 - 600

G1 would read "2"
G7 would read "4"
G13 would read "5"
G19 would read "1"
G25 would read "3"

Is this possible? is there a formula that can do this?



Posted by Chris Rock on September 18, 2001 7:17 PM

Next time I'll use the formula wizard first!!

The RANk() formula does just what I want!