find row index of a number in a list

[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

 

[The Red Cardinal]

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

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]

Ace! Thanks!

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


Cheers

Andrew

 

[The Red Cardinal]

Ace! Thanks!

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


Cheers

Andrew

Yes been there myself!

Thanks for letting me know it worked...