In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft Excel.
RANK.EQ Function in Excel
The RANK.EQ function in Excel returns the rank of a number against a list of other numeric values.
In case of duplicate entries in the array, RANK.EQ will assign the higher rank to each set of duplicates.
If you were to sort the list, the rank of the number would be its position.
Syntax
RANK.EQ(number,ref,[order])
Arguments:
- Number – The number whose rank you want to find.
- Ref – An array of, or a reference to, a list of numbers
- Order – A number specifying how to rank a number (Optional).
Possible Errors and Usage Notes
- When the Order is 0 or omitted, Excel by defualt ranks Number as if Ref were a list sorted in descending order.
- When the Order is any nonzero value, Excel by default ranks Number as if Ref were a list sorted in ascending order.
- Non-numeric values in Ref are ignored.
- Correction factor for tied ranks=[COUNT(ref) + 1 – RANK.EQ(number, ref, 0) – RANK.EQ(number, ref, 1)]/2.
How to use the RANK.EQ Function in Excel?
Using this function in a WS is simple; all you need to do is enter the function as a formula of the cell in the formula bar.
Take a look at the given example
Enter the data in the respective columns and enter the RANK.EQ function formula.
Formula: = =RANK.EQ (A2,B2)
Here, A2 refers to the cell name or the cell address. Column A denotes the Array.
You will get the result in the Result column.
