RANK.EQ

• How to use RANK.EQ formula?
• Examples of using RANK.EQ formula
• RANK.EQ formula not working?
• Similar formulas to RANK.EQ

Usage

Use the RANK.EQ formula with the syntax shown below, it has 2 required parameters and 1 optional parameter:

=RANK.EQ(value, data, [is_ascending])

1. value (required):
   The value whose rank you want to find.
2. data (required):
   An array or range of cells containing the list of values to rank.
3. is_ascending (optional):
   A logical value that specifies whether to rank the values in ascending order. If omitted or set to TRUE, the function ranks the values in ascending order. If set to FALSE, the function ranks the values in descending order.

Examples

Ranking students by test scores

Suppose you have a list of students and their test scores, and you want to rank them based on their scores. You can use the RANK.EQ function to assign a rank to each student's score, which will allow you to easily determine who scored the highest and lowest.

Identifying top sales performers

Suppose you have a list of salespeople and their sales figures, and you want to identify the top performers. You can use the RANK.EQ function to assign a rank to each salesperson's figures, which will allow you to easily identify the top performers and their relative standing.

Ranking sports teams by points scored

Suppose you have a list of sports teams and their points scored, and you want to rank them based on their scores. You can use the RANK.EQ function to assign a rank to each team's score, which will allow you to easily determine which teams scored the most points and which ones performed the worst.

Common Mistakes

Forgetting to include the value parameter

Make sure to include the value parameter in the formula, otherwise, the function will return an error.

Using an incorrect range for the data parameter

Be sure to select the entire range of values for the data parameter. If the range is too small, the function will return an error.

Omitting the is_ascending parameter

If the is_ascending parameter is omitted, the function will assume that the values are in ascending order. To rank values in descending order, set the parameter to FALSE.

Related Formulas

The following functions are similar to RANK.EQ or are often used with it in a formula:

• RANK.AVG

  RANK.AVG is a statistical function that returns the rank of a specified value within a dataset. The rank is determined by comparing the value to the other values in the dataset. This function is commonly used to determine the relative position of a value within a range of values.

• SORT

  The SORT formula in Google Sheets is used to sort a range of data based on one or more columns. This function can be used to sort data in ascending or descending order, and can also sort by multiple columns. The sorted data can be used for further analysis or presentation.

• FILTER

  The FILTER formula in Google Sheets is used to filter a range of data based on specified conditions. It returns a new range that only includes the rows that meet the specified conditions. This formula is commonly used to extract specific data from a larger dataset.

• INDEX

  The INDEX formula in Google Sheets is used to return a value or reference of a cell at the intersection of a specified row and column in a given range. The formula is commonly used to lookup and retrieve values from a table or range of cells.

• VLOOKUP

  The VLOOKUP function is a lookup formula used to search for a value in the first column of a range of cells (the search key) and return a value in the same row from a specified column in that range. This function is most commonly used to look up and retrieve data from a table.

Learn More

You can learn more about the RANK.EQ Google Sheets function on Google Support.