Calculating a rank of scores

[kieranbeunco]

In the file attatched, I am needing a formula or any other kind of way
to calculate the rank of each person with the set of scores.

Eg. For "Person 6", I am needing a "1" to be displayed next to their
name in column B to show that they are ranked number 1, BUT, if you
were to change their score in column C, a different rank should be
displayed, accordingly to the other 9 people in the range.

I require a way to display the correct rank for each person next to
their name. If anyone can help, it would be appreciated greatly. Cheers


Attachment filename: rank.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=551902

 

[xld]

Simply add a formula of
=RANK(C2,$C$2:$C$11)
in B2 and copy dow

 

[Frank Kabel]

Hi
in addition to the answer you already have received you may want to
take a look at:
http://www.cpearson.com/excel/rank.htm