Assign a rank (1st, 2nd, 3rd…) to each value in a list.
Copy this formula
=RANK.EQ(A2, $A$2:$A$100)RANK.EQ ranks a value against a locked range, highest first by default. Add a third argument of 1 to rank smallest first. Ties share the same rank.
=RANK.EQ(B2, $B$2:$B$50)→3This score is the 3rd highest.
Break ties with order
=RANK.EQ(A2,$A$2:$A$100)+COUNTIF($A$2:A2,A2)-1Gives tied values distinct ranks.
RANK.EQ is the modern name and behaves the same; RANK still works for compatibility.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.