Search Contextures Sites
Custom Search

 

More Excel Videos

Excel Videos - Index

Mouse Shortcuts

Pivot Table Tips

Names

Paste Special

 

 

Excel Video Tutorials RANK Function

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

Break Ties With the Excel RANK Function 

Split Prize Amounts for Ties in Excel RANK Function 

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 the Excel 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 Excel RANK Function

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

Get All the Excel News

For regular Excel news, tips, videos, and special offers, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

Last updated: May 30, 2016 10:21 AM