Summary

RANK.EQ returns the rank of a number in a list. If you sorted the list, the rank would be that value's position in the sorted order.

This is useful for leaderboards, score reports, sales standings, and any sheet where you want position instead of just the raw value. RANK.EQ is the classic tie-handling version, so tied values get the same rank.

Syntax

=RANK.EQ(number, ref, [order])

number is the value you want to rank, ref is the full list, and order controls whether ranking starts from the largest or the smallest.

Arguments

• number - [required] The number whose rank you want to find.
• ref - [required] The list of numbers to compare against. Non-numeric values in this list are ignored.
• order - [optional] Use 0 or omit it for largest-to-smallest ranking. Use a nonzero value like 1 for smallest-to-largest ranking.

RANK.EQ vs Other Functions

Using the RANK.EQ Function

Microsoft notes that if the order argument is 0 or omitted, Excel ranks the number as if the list were sorted from largest to smallest. If order is nonzero, Excel ranks it as if the list were sorted from smallest to largest. That means the same value can have a different rank depending on whether higher or lower numbers are considered better.

The tie behavior is what makes RANK.EQ distinct. If two values are tied, they both get the same top rank for that position. Microsoft also notes that this affects the next ranks. For example, in ascending order, if two values are tied at rank 5, the next value will be rank 7, not rank 6. This is the classic competition style ranking.

When you copy the formula down a column, it is usually best to lock the reference range with dollar signs like $B$1:$B$10. Otherwise the comparison range can shift and give the wrong ranks.

Example 1 - Rank a score from highest to lowest

This is the default setup and works well for scoreboards, sales lists, and competition tables.

=RANK.EQ(B1,$B$1:$B$10) // Returns the rank of B1 from highest to lowest.

Example 2 - Rank a value from lowest to highest

Use the optional order argument when lower numbers should rank better, such as times, wait lengths, or error counts.

=RANK.EQ(B1,$B$1:$B$10,1) // Returns the rank of B1 from lowest to highest.

Example 3 - See how tied values are handled

Tied values receive the same rank, and the next rank is skipped in the traditional way.

=RANK.EQ(B1,$B$1:$B$5) // Returns the shared rank for tied values.

Example 4 - Use rank as a quick standing check

This is useful when you want one cell to show the position of a specific result in the full list.

=RANK.EQ(B1,$B$1:$B$10) // Returns the position of B1 in the list.

Conclusion Recap

• Main job: RANK.EQ returns the position of a number in a list.
• Default order: If you omit the third argument, ranking is highest to lowest.
• Reverse order: Use 1 when lower values should rank better.
• Ties share the same rank: The next rank after a tie is skipped.
• Non-numeric values in the reference are ignored: Excel ranks against the numeric values only.
• Best practice: Lock the reference range with dollar signs when copying the formula.