RANK.EQ Function in Excel

RANK.EQ Function in Excel calculates and returns the statistical rank of a given value. When the value occurs multiple time then same rank is allocated to that value. i.e. in case of tie same rank is allocated to that value

Syntax of RANK.EQ Function in Excel

RANK.EQ( number, ref, [order] )
  • number – The value for which you want to find the rank.
  • ref – An array of values containing the supplied number.
  • [order] – order of the rank i.e. ascending or descending order. The [order] argument can have the value 0 or 1.
    • If 0 – ranked in descending order
    • If 1 – ranked in ascending order

 

Example of RANK.EQ Function in Excel in descending order:

RANK.EQ Function in Excel 1

  • If the numbers are same then the same rank is allocated to them. In our example the value 1020 is found twice and ranked 8th for both the occurrence .Rank 9 is left unused because we have given Rank 8 twice.
  • If the [order] argument is 0 then the rank is calculated in descending order. 

 

Example of RANK.EQ Function in Excel in ascending order:

RANK.EQ Function in Excel 2

  • If the [order] argument is 1 then the rank is calculated in ascending order.

previous-small RANK.EQ Function in Excel                                                                                                                next_small RANK.EQ Function in Excel