Hi John

Have a look at Excel's "RANK" formula
eg =RANK(B1,B1:B25,1)


--
XL2002
Regards

William



"JohnT" wrote in message
...
| 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)