Excel Function : RANK.EQ
Returns the rank of a number in a list of numbers
Microsoft Excel Reference Page
Syntax and Description of the RANK.EQ Excel Function
The RANK.EQ function syntax is =RANK.EQ(number, ref, [order]) number - The number whose rank you want to find ref - The array or range of data to consider [order] - The order to rank number in. Optional. Default is 0
About RANK.EQ Excel Function
The RANK.EQ function returns the rank of a number in a list of numbers. The rank is the position of the number in the list, with the first position being 1.