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