Position in a table

[Number_8]

I have a sweepstaake going for Euro 2004 football championships
Basically when anyone gets a score right they get points. At teh botto
of the lsit Ihave the total points each particpant has so far. What
want to to do is let each person know where they are points wise i
relation to everyon elese.

e.g So cell A1 has 3 points, A2 has 4 points, A3 has 2 points. I nee
B1 (relating to cell A1's points) to say that with 3 points you are i
"position 2", B2 to say "Position 1" etc. So teh highest number is te
best. The numbers will change daily so it needs to work it ou
automatically?

Cann you help?

thank

 

[Leo Heuser]

Have a look at the RANK function.

 

[Frank Kabel]

Hi
in addition to Leo's suggestion you may have a look at
http://www.cpearson.com/excel/rank.htm