The RANK.EQ returns the rank of a number relative to other numbers in a range or array.
For duplicate values, a rank of the first value is assigned.
This function allows you to find out what position a given number occupies in comparison with other numbers in the range.
Syntax
RANK.EQ(number, range, [order])
Argument |
Description |
Permitted values |
|---|---|---|
number |
Value for which the position is defined |
Any numerical value or reference to a cell containing a number |
range |
Array or range with a set of data that is taken into account in the calculation |
Range of cells or array of numbers |
[order] |
(optional) Boolean value that determines how values in a data set are sorted: ascending (TRUE) or descending (FALSE). By default, FALSE |
TRUE or FALSE |
Examples of use
Determining the rank of a number
=RANK.EQ(75, A1:A10)
If there are numbers in the range A1:A10, the function will return the rank of the number 75 among them.
Determining rank after sorting numbers in ascending order
=RANK.EQ(75, A1:A10, 1)
In this case, the function will determine the rank of the number 75 by arranging the numbers in ascending order.
Notes
–If there are duplicates in the array, the function will assign them the same rank, and the next rank will be skipped. For example, if two numbers have a rank of 2, the next number will receive a rank of 4.
–The function only works with numerical values. If there are text values in the array, they will be ignored.