Excel - Microsoft Excel RANK Function

Description

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

In Excel 2010, the Rank function has been renamed as the Rank.Eq function. However, the Rank function is still available in Excel 2010 (stored in the list of compatibility functions), to allow compatibility with earlier versions of Excel. 

The format of the function is : 

RANK( number, ref, [order] ) 

Where the function arguments are: 

Rank Function Examples

The following spreadsheet shows examples of the Excel Rank 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 Function Errors

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

Common Error