|
Re: 1st, 2nd, 3rd Place etc.....
Hi John
Have a look at Excel's "RANK" formula
eg =RANK(B1,B1:B25,1)
--
XL2002
Regards
William
willwest22@yahoo.com
"JohnT" <anonymous@discussions.microsoft.com> wrote in message
news:15d101c4f5f7$2a234be0$a401280a@phx.gbl...
| I have an idea how to do this but it requires a series of
| nested ifs and i'm sure there is a better way......in
| column A i have a list of names, column B is their scores
| and in C i would like to rank them in 1st, 2nd, 3rd etc....
| any ideas????
|
| (thanks in advance)
|