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

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

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 Picture 1

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:

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 Picture 2

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

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 Picture 3

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

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 Picture 4

- 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:

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 Picture 5

- 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!

Micah Soto

Update 19 May 2020

You should read it

May be interested

How to rank on Excel with RANK function
to rank on excel we will use the rank function. you can rank in ascending or descending order according to your needs.
ERROR.TYPE function - The function returns the number corresponding to one of the error values in Microsoft Excel
error.type function: the function returns the number corresponding to one of the error values in microsoft excel, or the # n / a error if there are no errors. syntax: error.type (error_val)
The use of the RANK function in excel
the rank function is a relatively common function and is widely used in the office world, and especially by accountants. so, what's the rank function for?
MAX function - The function returns the largest value in a set of values in Excel
max function: the function returns the largest value in the set of values. syntax: max (number1, [number2], ...)
MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel
month function: the function returns the month of a day expressed as serial number in excel. months are represented by integers with values between 1 and 12 months. syntax: month (serial_number)
STDEV.P function - The function returns the standard deviation based on the whole in Excel
stdev.p: the function returns the standard deviation based on the whole population, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.p (number1, [number2] ,.
How to use the RANK function in Excel
the rank function in excel is a function used by many people in data processing. for accountants, the rank function is very popular.
STDEV.S function - The function returns the standard deviation based on a sample in Excel
stdev.s function: the function returns the standard deviation based on a sample, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.s (number1, [number2], ...)
COUPNUM function - The function returns the number of interest payments on a security in Excel
in the process of investing in securities, paying special interest is very important. it helps you calculate and plan a reasonable calculation and investment. the following article details the coupnum function - the function returns the number of interest payments of securities in excel.
PROB function - The function returns the probability that values in a range are between two limits in Excel
prob function: the function returns the probability that values in a range are between two limits. syntax: prob (x_range, prob_range, [lower_limit], [upper_limit])