RANK.EQ
Formulas / RANK.EQRank 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.
=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.
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.
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?
How is the rank of a number returned by RANK.EQ?
What is the same as the position of the number in a sorted list?
What happens if the order argument is omitted?
What is the order argument?
