Using the Excel RANK.EQ Function
SummaryThe Excel RANK.EQ function returns the rank of a number in a list of numbers. Rank is determined by a number's size relative to other values in a set. If more than one value has the same rank, the top rank from the set of values is returned. In other words, if the list were sorted, the rank of the number would be its position within the list.
RANK.EQ, along with RANK.AVG, have replaced the RANK function. RANK is still available as a compatibility function.
Syntax=RANK.EQ (number, ref, [order])
Required. The number whose rank you wish to find.
Required. Array, or reference to, a list of numbers. Non-numeric values are ignored.
Optional. How you want to rank the numbers. The options include:
0 (zero) or omitted, the function ranks number as if ref was sorted in descending order.
Any non-zero number, the function ranks number as if ref was sorted in ascending order.
Usage NotesRANK.EQ returns the rank of a number when compared to other numbers in a list. If the number argument contains duplicate values, the function assigns the higher rank to both numbers. It isn't necessary to sort the values prior to using RANK.AVG.
If you want the largest value ranked #1, set the order argument to zero (0). If you want the smallest value to be ranked #1, set the order argument to 1 or any non-zero number.
To assign an average rank to duplicate values, use the RANK.AVG function.