Returns the rank of a number in a list of numbers.
Sintassi
RANK(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 function determines the size of a number relative to other values in a list. If multiple values have the same rank, the function assigns the same rank to each, but the presence of these values affects the ranks of subsequent numbers.
=RANK(A2, $A$2:$A$6)→1Ranks the value in A2 against the range A2:A6 in descending order.
Select the cell
Click the cell where you want the rank to appear.
Enter the formula
Type =RANK(number, ref) and ensure the reference range is locked with absolute references ($).
The RANK function assigns the same rank to both numbers, but it will skip the next rank in the sequence.