Home Application Office information

RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values ​​with the same rank in Excel

RANK.EQ function: The function returns the rank of a number in a list of numbers whose size is in correlation with other values. If multiple values ​​have the same rank -> the function returns the highest rank. Support functions from Execl 2010 version onwards.

The following article introduces you to the RANK.EQ function - one of the functions in the statistical function group is very popular in Excel.

Picture 1 of RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values ​​with the same rank in Excel

Description: The function returns the rank of a number in a list of numbers whose size is in correlation with other values. If multiple values ​​have the same rank -> the function returns the highest rank. Support functions from Execl 2010 version onwards.

Syntax: RANK.EQ (number, ref, [order])

Inside:

- number : The value you want to find rank, is a required parameter.

- ref: Array or reference to a list of numbers, is a required parameter.

- order: The number indicates the order of the rank, an optional parameter.

Attention:

- If order = 0 or omitted -> the default function sorts the terms in descending order.

- If order ≠ 0 -> the default function sorts the terms in ascending order.

For example:

Determine the rank of the value 66 in the data array described in the following data table:

Picture 2 of RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values ​​with the same rank in Excel

- Determine rank of 66 value in descending order. In a cell to calculate, enter the formula : = RANK.EQ (D6, D7: J7, D8)

Picture 3 of RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values ​​with the same rank in Excel

- Press Enter -> rank of the value 66 is:

Picture 4 of RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values ​​with the same rank in Excel

- Here the ref array has 3 values ​​66 -> the function returns the highest rank is 1 (corresponding to descending arrangement).

- Determine rank of 66 value in ascending order. In the cell to be calculated enter the formula : = RANK.EQ (D6, D7: J7, D8) -> Press Enter -> return value is:

Picture 5 of RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values ​​with the same rank in Excel

- Here the ref array has 3 values ​​66 -> the function returns the highest rank is 5 (corresponding to ascending arrangement).

So with 2 different arrangements -> rankings of the same value are different.

Above are instructions and some specific examples when using the RANK.EQ function in Excel.

Good luck!

You've just finished reading the article "RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values ​​with the same rank in Excel" edited by the TipsMake team. You can save rankeq-function-function-returns-the-rank-of-a-number-in-a-list-of-numbers-returns-the-highest-rank-when-multiple-values-​​with-the-same-rank-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV Operations with blocks in Excel
NEXT » PROB function - The function returns the probability that values ​​in a range are between two limits in Excel
Read more