Returns the rank of a number in a list of numbers.
Sintassi
RANK.EQ(number, ref, [order])Argomenti
numberobbligatorio
The number whose rank you want to find.
refobbligatorio
An array of, or a reference to, a list of numbers.
orderfacoltativo
A number specifying how to rank; 0 or omitted for descending, any non-zero value for ascending.
The RANK.EQ function identifies the position of a specific value relative to other values in a provided range. If multiple values have the same rank, the top rank is assigned to that set of values.
=RANK.EQ(85, {70, 85, 90, 85})→2Returns 2 because 85 is the second highest value in the list.
Select the cell
Click on the cell where you want the rank to appear.
Enter the formula
Type =RANK.EQ( followed by the target number, the range, and the optional order argument.
RANK.EQ assigns the same rank to all tied values, which may affect the rank of subsequent numbers.