|  

» Ranking a List of Numbers

Problem:

Columns A & B list the names of the players who took part in the last game and their respective scores.
We want to rank all the scores, in both descending and ascending order.

Solution:

To rank the scores in descending order (labeling the highest score as 1), use the RANK function in the following formula:
=RANK(B2,$B$2:$B$9,0)

To rank the scores in ascending order (labeling the lowest score as 1), use the RANK function in the following formula:
=RANK(B2,$B$2:$B$9,1)


Rate This Tip
12 34 5
Rating: 2.54     Views: 14602
No comments have been submitted.
Name
Comment Title
Comments