Ranking, I think

[Stephen]

I have a column of values which I need to rank from highest, 1, to lowest,
18.
Help please as I can't find anything on google.

 

[Jim Cone]

Have you considered sorting them ascending?
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
Special Sort Excel add-in (30 ways to sort)




"Stephen" <[email protected]>
wrote in message
news:1897767531354160081.929678steve-dmsystems.co.nz@news.eternal-september.org...

 

[Stephen]

Have you considered sorting them ascending?

If I do that I lose the alpha order the rows are I need them in.

 

[Ron Rosenfeld]

I have a column of values which I need to rank from highest, 1, to lowest,
18.
Help please as I can't find anything on google.

How about using the RANK worksheet function?

 

[Jim Cone]

In Excel help, search for the Rank function. The explanation is fairly straight forward.
A Rank formula in an adjoining column might look like...
=RANK(A2,$A$2:$A$30,ROW()-1)
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Data Options add-in: rows/dates/random stuff)




"Stephen" <[email protected]>
wrote in message