How to Rank Values in Excel (with Tie Rules)
Ranking means pinning an absolute range in RANK.EQ for every cell — and if you want dense ranking rather than gaps after ties, you're back to hand-built COUNTIF tricks. Here's why, and the one-click way with the tie rule you choose.
Last updated: August 2026
| Value | Rank (standard, high→low) | |
|---|---|---|
| 90 | → | 1 |
| 70 | → | 3 |
| 90 | → | 1 |
Why RANK is fiddly
RANK and RANK.EQ need an absolute range such as $B$2:$B$99 repeated in every cell, and it's easy to forget a dollar sign and get a range that drifts. Worse, they only do standard ranking — 1, 2, 2, 4 — with gaps after ties. If you want dense ranking (1, 2, 2, 3) there's no option to flip; you rebuild it with a COUNTIF-based formula. Two different formulas for two common rules, both needing careful anchoring.
The 1-click way — Tellsheet's Rank
Select the numeric column and run Rank. Choose highest-first or reverse, and a tie rule — standard (1,2,2,4) or dense (1,2,2,3) — and it adds a rank column in one pass with no absolute range to pin. The rows stay in place; the rank sits beside each one as a real number. Pairs with Top N per Group and Sort by Multiple Columns.
Frequently asked questions
How do I rank values in Excel?
The built-in way is RANK.EQ with an absolute range in every cell. Rank adds the column in one click, with a choice of standard or dense ties.
What's the difference between standard and dense ranking?
Standard leaves gaps after ties (1,2,2,4); dense has none (1,2,2,3). Rank lets you pick either from a switch.
Can I rank lowest to highest?
Yes — choose the direction, so it works for leaderboards as well as fastest times or smallest costs.
Does it change my data order?
No — it adds a column beside your data and leaves the rows where they are.
Related Excel guides
Rank a column in one click
Rank adds a rank column with standard or dense tie handling, in either direction — no anchored RANK.EQ to maintain.
Get Tellsheet free See pricing