Excel probs!!

[Stig]

Hello!
Can anybody please help me to sort a resultlist in excel?
I have a total number of points on each of my participator, then i want
excel to count the score and give them a number.
I want the person with the highest score to be number 1 end so on...

Happy for answere!

Stig

 

[Govind]

Hi,

Lets say the scores are in cells B1:B10 then use this formula in column
c to find out the rank

=RANK(B1,$B$2:$B$10)

and copy it down till B10.

Regards

Govind.

 

[Govind]

Oops. sorry. the formula should be

=RANK(B1,$B$1:$B$10)

Regards

Govind.

 

[Frank Kabel]

Hi
in addition see:
http://www.xldynamic.com/source/xld.RANK.html