RANK.EQ

Formulas / RANK.EQ
Rank a number against other numeric values.
RANK.EQ(number, ref, [order])
  • number - the number whose rank is being found (required)
  • ref - an array of or reference to a list of numbers (required)
  • order - [OPTIONAL] a number that determines how to rank number

Examples

  • =RANK.EQ(C5,points)

    The RANK.EQ function returns the rank of a value compared to other values in a list. For example, if we wanted to calculate the rank of the value in cell C5 compared to the values in cells C5:C12, we would enter the preceding formula into the cell.

  • In the example above, the value in cell C5 is compared to the list of values in cells C5:C12. If the value in cell C5 is the highest value of all the values in the range C5:C12, the formula will return the value 1. If the value in cell C5 is the second highest value in the range C5:C12, the formula will return the value 2, and so on.

  • =RANK.EQ(C5,D5:D12)

    The RANK.EQ function can also be used to compare a value to a list of values in a different range. For example, if we wanted to compare the value in cell C5 to the values in cells D5:D12, we would enter the formula above into the cell.

Summary

The RANK.EQ function ranks a number against other given numbers and returns a rank indicating its position. It takes three arguments: the number, ref, and order.

  • The RANK.EQ function returns the rank of a number within a list of other numeric values, with two modes of ranking controlled by the order argument: largest value is ranked #1, or smallest value receives #1.
  • The order argument can also be used to rank values with duplicates, setting it to 1.


Frequently Asked Questions

What is the RANK.EQ function?
The RANK.EQ function is a function that returns the rank of a number in a list of objects. The rank of a number is the position of the number in the list.
How is the rank of a number returned by RANK.EQ?
The rank of a number is returned by RANK.EQ if the order argument is omitted.
What is the same as the position of the number in a sorted list?
The rank of a number is the same as the position of the number in a sorted list.
What happens if the order argument is omitted?
If the order argument is omitted, the rank of a number is returned by RANK.EQ.
What is the order argument?
The order argument is a parameter that can be used to specify the order of the items in the list. If the order argument is 0, the rank of a number is returned by RANK.EQ.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.


Drop CSV