You can return the rank of a number in a column of numbers. The Rank function works as if you were to sort the list in descending order. In this example, Amount Sales values are ranked for each Country.
The Rank function assigns duplicate numbers the same rank, which affects the ranks of subsequent numbers. |
