Search
Contextures Sites
| |||
|
|
|
|||
Contextures Inc., Copyright ©2013
All rights reserved.
Search Contextures Sites
Excel Video Tutorials RANK Function
How to use the Excel RANK Function
Break Ties With the Excel RANK Function
Split Prize Amounts for Ties in Excel RANK FunctionHow 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
Contextures Inc., Copyright ©2013
All rights reserved.
Last updated: May 22, 2013 7:41 PM
