Excel function · Statistics
RANK.EQ
Returns a number's rank in a list: 1 for the largest by default.
What it does
RANK.EQ tells you where a number stands in a list. By default the largest is 1st; with order 1 the smallest is 1st. Equal numbers share a rank, and the next rank is skipped.
Syntax
=RANK.EQ(number, ref, [order])Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ,
Arguments
- number
- The number to rank, usually a cell.
- ref
- The full list it is ranked in. Lock it with $ before filling the formula down.
- order
- 0 or left out: the largest is 1st. 1: the smallest is 1st, as for race times.
Example
Where does Kai's score of 85 rank in the class?
| A | B | C | |
|---|---|---|---|
| 1 | Student | Score | Rank |
| 2 | Ana | 78 | |
| 3 | Ben | 91 | |
| 4 | Kai | 85 | 2 |
| 5 | Lia | 70 |
The formula in C4:
=RANK.EQ(B4,B2:B5)Result: 2
Only Ben's 91 is higher, so 85 is second: the result is 2.
Common mistakes
- Filling the formula down without $ on the list, so the list shifts with each row and the ranks come out wrong.
- Ranking times from the largest. For times, use order 1 so the fastest is 1st.
In other Excel languages
Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.
| Excel language | Function name | Separator |
|---|---|---|
| English | RANK.EQ | , |
| Deutsch | RANG.GLEICH | ; |
| Français | EQUATION.RANG | ; |
| Español (España) | JERARQUIA.EQV | ; |
| Español (México) | JERARQUIA.EQV | , |
| 日本語 | RANK.EQ | , |
| 한국어 | RANK.EQ | , |
| 繁體中文 | RANK.EQ | , |
| ไทย | RANK.EQ | , |
| ខ្មែរ | RANK.EQ | , |
| Tiếng Việt | RANK.EQ | ; |