RANK.AVG Function Explained
The RANK.AVG Function in Microsoft Excel returns the rank of a number in a list of numbers. It returns the rank as a number, with the largest number in the list being 1, the second largest number in the list being 2, and so on. It takes two arguments: the number whose rank is to be found, and the list of numbers to rank against.
RANK.AVG Function Syntax
RANK.AVG(number,ref,order)
- number: The number whose rank you want to find.
- ref: An array of, or a reference to, a list of numbers. Nonnumeric values in ref are ignored.
- order: A number specifying how to rank number. If order is 0 (zero) or omitted, Excel ranks number as if ref were a list sorted in descending order. If order is any nonzero value, Excel ranks number as if ref were a list sorted in ascending order.