RANK.AVG

The RANK.AVG 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 average rank of the entries will be returned.

Function Syntax and Parameters

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

Parameters:

• value: The value for which the rank needs to be determined.
• data: The dataset containing the values.
• [is_ascending]: [Optional] Determines whether the ranking is done in ascending order. The default value is TRUE.

Use Cases and Scenarios

1. Sales Analysis: Determine the ranking of each product based on their sales figures.
2. Academic Grades: Rank students based on their exam scores.
3. Competition Standings: Calculate the rankings of participants in a sports tournament.

Related Articles

• Top 4 Basic Statistical Functions Every Google Sheets User Should Know
• 10 Essential Google Sheets Formulas for Data Analysis