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.

Go to my Contextures site for written steps and sample file.
[ Ссылка ]

свернуть