find row index of a number in a list

  • Thread starter Thread starter Trull
  • Start date Start date
T

Trull

I have a column of numbers, in no particular order.
In the column next to it, I want to write a 1 next to the highest number, 2
next to the 2nd highest and so on. How can I do this?


Thanks in advance,

Andrew
 
Trull said:
I have a column of numbers, in no particular order.
In the column next to it, I want to write a 1 next to the highest
number, 2 next to the 2nd highest and so on. How can I do this?


Thanks in advance,

Andrew
Click to expand...


You would use the RANK command:

=RANK(Cell, Array of Cells, Order),

e.g. if your cells were A1:A20, in B1 you would write:

=RANK(A1, A1:A20, 1)

For ease, if you used absolute references for the range, you could just copy
and paste for the whole B column then:

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

The one is not important here - just tells Excel to count in ascending
order.

Hope this works...
 
Trull said:
Ace! Thanks!

Been trying Index, Choose etc, Rank! i'd never have guessed!


Cheers

Andrew
Click to expand...

Yes been there myself! :-)

Thanks for letting me know it worked...
 
Back
Top