Excel + Google Sheets · RANK.EQ
Rank anything automatically
Gives each number its position in a list. The $ keeps the range fixed.
The formula
=RANK.EQ(B2, $B$2:$B$5)What each part means
B2The number$B$2:$B$5Compared with this list
Example
| A | B | C | |
|---|---|---|---|
| 1 | Rep | Sales | Rank |
| 2 | Laura | 1,250 | |
| 3 | João | 980 | |
| 4 | Priya | 2,410 | |
| 5 | Tom | 640 |
| A | B | C | |
|---|---|---|---|
| 1 | Rep | Sales | Rank |
| 2 | Laura | 1,250 | 2 |
| 3 | João | 980 | 3 |
| 4 | Priya | 2,410 | 1 |
| 5 | Tom | 640 | 4 |
Step by step
- Click cell C2.
- Type the formula:
=RANK.EQ(B2, $B$2:$B$5) - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English RANK.EQ
- Español JERARQUIA.EQV
- Português ORDEM.EQ