The RANK.EQ function calculates the rank of a number in a list of numbers, based on its position if the list were sorted.
Formula in cell C7:
The image below shows the position of number 10 if the list were sorted in an descending order.
This list sorted in a descending order shows number 10 in position 6 which is the rank the RANK.EQ function calculates in cell F2 in the top image. Note that the last duplicate (10) also gets rank 6 and not 7 as the image above shows.
Excel Function Syntax
Required. A list of numbers.
Optional. This argument determines how the RANK.EQ function ranks a number.
0 (zero) - Default value, list in argument ref is sorted in a descending order.
1 - List in argument ref is sorted in an ascending order.
RANK.EQ function ignores non-numeric values in ref argument.
The RANK.EQ function calculates the same rank to duplicate identical numbers, however, it also moves the ranks for the following numbers. This example calculates ranks based on a list sorted in an ascending order.
Formula in cell C3:
10 has a duplicate number, both numbers get the same rank. The following number is 21, that number gets rank 3. No number has rank 2.
If you want the to give duplicate numbers a unique rank use the following formula:
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Statistical'
The RANK.EQ function function is one of many functions in the 'Statistical' category.