RANK.EQ
Returns the rank of a number in a list. If multiple values tie, all share the same (highest) rank. Modern, identical replacement for the legacy RANK function.
RANK.EQ(number, ref, [order])Arguments
numberThe number whose rank you want to find.refReference to the list of numbers.orderOptional. 0 or omitted = descending; non-zero = ascending.(optional)
=RANK.EQ(10,{10,10,20,30})Both 10s share rank 3 (next is rank 5, not 4)
- •Available since Excel 2010 — same result as the legacy RANK
- •Use RANK.AVG if you want ties to receive the average rank
- •Returns #N/A if number is not in ref
- •Expecting tied values to receive different sequential ranks - RANK.EQ gives every tied value the same rank, and the next distinct value skips ahead accordingly (two values tied for 3rd means the next rank is 5, not 4)
- •Forgetting that the order argument controls ascending versus descending ranking, and getting the default (descending) backward from what's actually needed for a particular dataset
- •Referencing a number that isn't actually present in ref, which returns a #N/A error rather than the nearest rank
RANK.AVGAverages the rank of tied values instead of giving them all the same rank, a different tie-breaking approach than RANK.EQ.LARGEFinds the value at a specific rank position, roughly the inverse operation of what RANK.EQ determines.COUNTIFCan be combined to manually replicate ranking logic, or to check how many values tie at a particular rank before interpreting RANK.EQ's output.Why do two tied values both show rank 3, and then the next value shows rank 5 instead of 4?
That's expected - RANK.EQ gives every tied value the same (highest) rank, and skips the ranks that would have belonged to the tied entries, so the next distinct value's rank accounts for both ties.
What does the order argument do in RANK.EQ?
It controls the ranking direction - 0 or omitted ranks in descending order (largest number gets rank 1), while any non-zero value ranks in ascending order (smallest number gets rank 1).
Is RANK.EQ the same as the legacy RANK function?
Yes, they produce identical results - RANK.EQ is simply the modern, more clearly named equivalent, distinguishing it from RANK.AVG which handles ties differently.
Need to translate a formula using RANK.EQ?
Use our translator to convert your complete formula