Excel like a finance pro.
← The libraryPractice · 6 questions →
Compatibility function
RANK
Returns the rank of a number in a list; still widely typed but RANK.EQ is the current name.
CommonDifficulty 1100 · ProficientUsage rank #163 of 520
When to use it
The rank of a number in a list. Still the most typed form; RANK.EQ is the current name with identical results.
The shape of it
- Syntax
=RANK(number, ref, [order])
- Example
=RANK(B2,$B$2:$B$20)
Worked examples
Ties
=RANK(85,{70,85,90,85}) → 2
Ties share rank 2.
Ascending
=RANK(70,{70,85,90,85},1) → 1
Ascending.
Rank a column
=RANK(B2,$B$2:$B$20) → 7
Copied down a column.
Worth knowing
- RANK.EQ is identical; RANK.AVG averages ties.
- Lock the reference range.
- Order 0 or omitted is descending.
Where it goes wrong
- #N/A when the number is not in the list.
- Skipped ranks after ties.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.