Excel - Microsoft Excel RANK.EQ Function

Description

The Excel RANK.EQ function returns the statistical rank of a given value, within a supplied array of values. If there are duplicate values in the list, these are given the same rank. 

The Rank.Eq function is new in Excel 2010, and so is not available in earlier versions of Excel. However, the function is simply a renamed version of the Rank function that is available in earlier versions of Excel. 

The format of the function is : 

RANK.EQ( number, ref, [order] ) 

Where the function arguments are: 

RANK.EQ & RANK.AVG Functions 

The Rank.Eq and Rank.Avg functions are both new to Excel 2010. The difference between these two functions occurs when there are duplicates in the list of values. The Rank.Eq function returns the lower rank, whereas the Rank.Avg function returns the average rank. 

For example, in the list of values 4, 5, 5, 6 (in ascending order), the value '5' occupies the 2nd and 3rd positions. Therefore, when calculating the rank of the value 5 : 

Both the Rank.Eq and the Rank.Avg function return a rank of 4 for the value 6. 

Rank.Eq Function Examples

The following spreadsheet shows examples of the Excel Rank.Eq Function used to calculate the rank of values within the simple set {1, 11, 6, 9, 2, 5, 9}. 

The format of the functions are shown in the spreadsheet on the left and the resulting values are shown in the spreadsheet on the right. 

Rank.Eq Function Error

If you get an error from the Excel Rank.Eq function this is likely to be the #N/A error : 

Common Error