return rating of which number is highest and descending in column

A

andemor

i have a large amount of numbers in a column, i want to keep them in the same
order, but in the column next to it i would like the rating of which is the
highest, which is second highest and so on. hope you can help me
 
M

Mike H

Assumes your numbers in A1 - A15 put this in B1 and drag down

=RANK(A1,A$1:A$15)



Mike
 
M

MartinW

Also try this,
Put 1 to 15 in A1 to A15
Put Mike's formula in B1 and This formula in C1 =LARGE(A$1:A$15,ROW())
Drag both formulas down to row 15

Now change the data in column A and watch the difference in the
in their returns.

HTH
Martin
 
Top