RANK.EQ Function Explained
The RANK.EQ Function in Microsoft Excel returns the rank of a number in a list of numbers. It has two arguments: number (the number whose rank you want to find) and ref (the list of numbers to rank against). It returns the rank of the number as a number. If more than one number has the same rank, the average of their ranks is returned.
RANK.EQ Function Syntax
RANK.EQ(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.