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

`=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.

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.

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.

The rank of a number is returned by RANK.EQ if the order argument is omitted.

The rank of a number is the same as the position of the number in a sorted list.

If the order argument is omitted, the rank of a number is returned by RANK.EQ.

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.

Drop CSV