SheetFX
≡
<< Go back to all functions

RANK.EQ

The RANK.EQ function in Google Sheets returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned.

Function Syntax and Parameters

Syntax: RANK.EQ(value, data, [is_ascending])

Parameters:

  • value: The value for which you want to find the rank.
  • data: The range or array containing the dataset.
  • is_ascending: [Optional] A logical value that specifies the ranking order. If set to TRUE or omitted, the values will be ranked in ascending order. If set to FALSE, the values will be ranked in descending order.

Step-by-Step Tutorial

  1. Using RANK.EQ with a single value and dataset:

    • Example: =RANK.EQ(80, A1:A10)
    • Result: 3

  2. Changing the ranking order:

    • Example: =RANK.EQ(80, A1:A10, FALSE)
    • Result: 8

Use Cases and Scenarios

  1. Competition Ranking: Determine the rank of a player in a sports tournament.
  2. Exam Results Analysis: Find the position of a student in a class based on their test scores.
  3. Sales Performance Evaluation: Rank sales representatives based on their quarterly sales figures.

Related Functions

  • RANK: Returns the rank of a specified value in a dataset, where the rank of the ties is determined by their order in the dataset.
  • RANK.AVG: Returns the rank of a specified value in a dataset, where the rank of the ties is averaged.

Related Articles