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:
If the [order] argument is omitted, it will take the default value of 0, i.e. decending order. Any nonzero 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
