Ranking values in a series?

[Guest]

IS there a way of ranking a value in a series from lowest to highest or vice versa?

 

[Leo Heuser]

Charlie

Have a look at the RANK() function.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

IS there a way of ranking a value in a series from lowest to highest or

vice versa?

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/rank.htm

 

[Guest]

Thanks that works perfectly.

 

[Leo Heuser]

You're welcome.