The RANK function returns the rank of a number in a list of numbers.

1. If the third argument is omitted (or 0), Excel ranks the largest number first, second largest number second, etc.

Descending Order

Note: when we drag the RANK function down, the absolute reference ($A$1:$A$9) stays the same, while the relative reference (A1) changes to A2, A3, A4, etc.

2. If the third argument is 1, Excel ranks the smallest number first, second smallest number second, etc.

Ascending Order

3. Use the RANK.AVG function to return the average rank if more than one number has the same rank.

Average Rank

5/14 Completed! Learn more about statistical functions >
Go to Next Chapter: Round   |   Become an Excel Pro: 300 Examples