Google Sheets RANK.EQ Function: Syntax, Examples & Tips

value:
The number or cell reference for which you want to find the rank within the specified data range.

data:
The range of cells that contains the values you want to rank against.

is_ascending:
An optional parameter that determines the ranking order. If TRUE or omitted, ranks in ascending order; if FALSE, ranks in descending order.

What is RANK.EQ?

The RANK.EQ function in Google Sheets is a statistical tool used to determine the rank of a specific value within a dataset. It assigns a rank to each number in a list, with the highest number receiving a rank of 1. If there are duplicate values, they will receive the same rank, and the next rank will be skipped. This function is particularly useful for comparing scores, sales figures, or any numerical data where ranking is required.

In simpler terms, RANK.EQ allows you to see how a particular value stands in relation to others in a dataset.

A Practical Example

Imagine you are tracking the scores of students in a class:

Scores Table:

You want to rank the students based on their scores.

RANK.EQ Formula

To achieve this, you would use the RANK.EQ function as follows:

=RANK.EQ(B2, $B$2:$B$6, 0)

In this formula:

• B2 is the cell containing the Score for the student you want to rank.
• $B$2:$B$6 is the range of scores you are evaluating.
• 0 indicates that you want to rank in descending order (highest score gets rank 1).

Result of the Formula

When you apply the RANK.EQ formula to the Scores Table, the output would look like this:

In this case, both Alice and Charlie have the same score of 85, so they both receive a rank of 3, while the next rank (4) is skipped.

Why Use RANK.EQ?

RANK.EQ is beneficial because it provides a straightforward way to rank data without the need for complex calculations. It helps in quickly identifying top performers or lowest scores in a dataset. Additionally, it can be used in conjunction with other functions to create more comprehensive analyses.

Key Takeaways:

• RANK.EQ: A Google Sheets function that ranks a number within a dataset.
• Handling Duplicates: Assigns the same rank to duplicate values and skips the next rank.
• Descending Order: Can rank data in descending order, making it easy to identify top values.
• Common Use Cases: Ideal for ranking scores, sales figures, or any numerical data where comparison is needed.

RANK.EQ is an essential function for anyone working with numerical data in Google Sheets, providing a simple yet effective way to analyze and present rankings.

Happy spreadsheeting!