Ranking is the process of arranging things in order according to a set of criteria. In Google Sheets, the RANK.EQ function can be used to rank data according to a specific criterion. The function takes a single argument, which is the column of data that you want to rank. The function will return the rank of the first value in the column that meets the criterion. If there are no values in the column that meet the criterion, the function will return the rank of the last value in the column.
The syntax of the RANK.EQ function in Google Sheets is as follows:
reference - The reference to the cell or range of cells you want to rank.
rank_num - The rank of the cell or cells you want to find.
RANK.EQ allows you to compare two values and determine which is higher. In the example below, the rank of the student's score is shown in column A and the student's name is shown in column B.
There are a few occasions when you should not use the RANK.EQ function in Google Sheets. One instance would be when you want to compare two items that are not in sequential order. For example, if you wanted to compare the sales of two products that were not released in the same month, you would not be able to use the RANK.EQ function. Additionally, you should not use the function when you want to compare two items that are not in the same category. For example, you would not be able to compare the sales of a car and a TV using the RANK.EQ function.
There are a few similar formulae to RANK.EQ in Google Sheets. The most similar is RANK.AVG, which returns the rank of a value within a list of values, but averages the rank if there is a tie. Another similar formula is RANK.MIN, which returns the rank of a value within a list of values, but returns the smallest rank if there is a tie. Finally, RANK.MAX returns the rank of a value within a list of values, but returns the largest rank if there is a tie.