RANK.EQfunction returns the rank of a specified value in a list of numbers. The rank of a number is its size relative to other values in the list. It is often used to determine the relative standing of values in a dataset. The function can be used to rank values in ascending or descending order, and can handle ties in several ways.
- How to use
- Examples of using
RANK.EQformula not working?
- Similar formulas to
RANK.EQ formula with the syntax shown below, it has 2 required parameters and 1 optional parameter:
- value (required):
The value whose rank you want to find.
- data (required):
An array or range of cells containing the list of values to rank.
- 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.
ExamplesHere are a few example use cases that explain how to use the
RANK.EQformula in Google Sheets.
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.
RANK.EQnot working? Here are some common mistakes people make when using the
RANK.EQGoogle Sheets Formula:
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.
The following functions are similar to
RANK.EQ or are often used with it in a formula:
RANK.AVGis 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.
SORTformula 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.
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.
INDEXformula 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.
VLOOKUPfunction 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.
You can learn more about the
RANK.EQ Google Sheets function on Google Support.