Summary
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.
Purpose
Rank a number against a range of numbers
Return value
A number that indicates rank.
Syntax
=RANK (number, array, [order])
Arguments
- 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.
Usage notes
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.