EXCEL RANK.EQ FUNCTION

The RANK.EQ function in Excel delivers the statistical rank of a given value inside an array of values. If there are duplicate values in the list, they are ranked the same.

Syntax :

=RANK.EQ( numberref[order] )

Parameters :

  • The following argument are:

number –

  • The value for which you wish to calculate the rank.

ref –

  • A value array holding the provided number.

[order] –

  • An optional parameter specifying whether the given ref array should be arranged ascending or descending.
    The [order] option can have a value of 0 or 1, which means:
  • 0 – use descending order;
  • 1 – use ascending order.
    1st – use ascending order
    If the [order] option is missing, the default value of 0 is used (i.e. descending order). Any non-zero number is assumed to be the value 1. (i.e. ascending order).

Step By Step Guide of RANK.EQ Function

Example :

The spreadsheet below illustrates four examples of the Excel Rank.Eq Function, which is used to compute the rank of items in the array 1, 11, 8, 9, 2, 5, 9.

  • #N/A – This error occurs if the specified number is not found inside the supplied ref.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now