The Excel RANK function returns the rank of a numeric value when compared to a list of other numeric values. RANK function can arrange values from largest to smallest as well as smallest to largest values, using an optional order argument.
- number – The number to rank.
- array – An array that contains the numbers to rank against.
- order – [optional] Whether to rank in ascending or descending order.
Use RANK when you want to provide a rank for items in a list, but you don’t want to sort the list.
The default for order is 0 = descending order:
If order is 0 or omitted, number is ranked by position against the numbers in array sorted in descending order.
If order is 1, then number is ranked by position against the numbers in array sorted in ascending order.