Syntax
RANK.EQ(number, ref, [order])
| Parameter | Description |
|---|---|
| number | Parameter of the RANK.EQ function. |
| ref | Parameter of the RANK.EQ function. |
| [order] | (Optional.) Parameter of the RANK.EQ function. |
Examples
Leaderboard position
Formula
=RANK.EQ(D10, $D$2:$D$100)
Returns the rank of the player in row 10 among 99 players. If their score of 850 is the 5th highest, returns 5.
Lowest price rank
Formula
=RANK.EQ(C3, $C$2:$C$20, 1)
Ranks suppliers by price with the cheapest as rank 1. Setting order to 1 gives ascending ranking.
Conditional formatting helper
Formula
=RANK.EQ(B2, $B$2:$B$50) <= 3
Returns TRUE for the top 3 values — useful as a conditional formatting rule to highlight top performers.
Common Errors
#N/A
The value is not found in the reference array.
#VALUE!
Non-numeric input was provided.
Tips
Same as RANK
RANK.EQ is functionally identical to RANK. The .EQ suffix emphasizes that ties receive equal (same) rank numbers.
Top-N filtering
Use RANK.EQ(value, range) <= N to identify the top N items. This works well with FILTER or conditional formatting.
Unique ranks with tiebreaker
To break ties, add a small tiebreaker: =RANK.EQ(B2,$B$2:$B$50) + COUNTIF($B$2:B2, B2) - 1 ensures every item gets a unique rank.
Try RANK.EQ in Viztab
Import your data and use RANK.EQ with 370+ other formulas. No signup required.
Open Viztab