[SOLVED] Ranking a List of Numbers

[Travis]

I would like to know how to rank the whole list at once...NOT rank them one at a time - if all the data is listed in the B column, I would like to use one formula to make all the ranking numbers appear in the C column.

[ExcelTip]

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)