Related Function:

The 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.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.
  • The RANK.EQ function replaces the RANK function included in earlier versions of Excel.

Syntax

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

Arguments

Argument Description
number Specifies the name of a parameter
ref  
[order] The number of coupon payments per year. Must be one of the following:

  0 Ranks number as if ref were a list sorted in descending order
  1 Ranks number as if ref were a list sorted in ascending order

If the [order] argument is omitted, it will take the default value of 0, i.e. decending order. Any non-zero value is treated as the value 1, i.e. ascending order

Examples

  A B C D E
1 Data   Formula Result Notes
2 9   =RANK.EQ(9,A2:A8) 6 Rank of 9 in the list contained in the range A2:A8, sorted highest to lowest
3 37   =RANK.EQ(9,A2:A8,1) 2 Rank of 9 in the list contained in the range A2:A8, sorted lowest to highest
4 20        
5 6        
6 16        
7 26        
8 32        

Note: 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.

Common Function Error(s)

Problem What went wrong
#N/A Occurs if the supplied number is not present in the supplied array of values

  the function does not recognize text representations of numbers as numeric values, so you will also get the #N/A error if the values in the supplied ref array are text values