RANK.EQ
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.