Goal: Assign a Rank based on Score.
Notice how Ties (Duplicate Scores) are handled differently by EQ and AVG.
Ready...
💻 Formula Structure
=RANK.EQ(number, ref, [order])
- Logic: Ties share the top rank. (e.g. 1, 2, 2, 4). No rank 3.
- Legacy: This replaces the old
RANK function.
=RANK.AVG(number, ref, [order])
- Logic: Ties split the rank points. (e.g. 1, 2.5, 2.5, 4).
- Math: (Rank 2 + Rank 3) / 2 = 2.5.
-- Select a ranking style...
...
⚠️ Common Pitfalls
🚫 Skipping Ranks
In standard ranking (EQ), if two people tie for 2nd, the next person is 4th. The rank "3rd" is skipped entirely. This is normal behavior.
📉 Sort Order
The 3rd argument [order] matters!
0 (Default): Descending (Highest score = #1).
1: Ascending (Lowest score = #1, like golf or race times).