# Excel RANK Function Videos

Short videos show how to use the RANK function, how to break ties when using the RANK function, and more tips

## How to use the Excel RANK Function

Use the Excel RANK function to compare numbers to other
numbers in the same list. Show which student got the highest test
score, or which player had the lowest score in a round of golf. .

For written instructions for this Excel RANK function
tutorial, see the Contextures Blog article: Calculating RANK in Excel

## Break Ties With RANK
Function

If ties occur in the rankings, when using the Excel RANK function,
use a formula in the adjacent column to break the ties, based on another
number, such as how much time each student spent writing the test.

For written instructions for this Excel RANK function tutorial,
see Break Ties With the
Excel RANK Function

## Split Prize Amounts for Ties in
RANK

Use the Excel RANK function to compare numbers to other numbers in
the same list. Show which player got the highest game score, and which
player had the lowest score.

If ties occur in the rankings, use a formula in the adjacent column
to split the prize amounts for tied players. For example, 3 players
ranked in second place would share the prize amounts for 2nd, 3rd
and 4th place. The next highest ranked player would get the 5th place
prize amount.

For written instructions for this Excel RANK function tutorial, see
Split Prize Amounts for Ties in
Excel RANK Function

## More Excel Videos

Excel Videos - Index

Mouse Shortcuts

Pivot Table Tips

Names

Paste Special