» 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)