Function RANK (RANK) returns the rank of a number in a list of numbers.
- If the function’s third argument is omitted (or equal to 0), Excel sorts the numbers as follows: the largest number comes first, the second largest number comes second, and so on.
=RANK(A1,$A$1:$A$9)=РАНГ(A1;$A$1:$A$9)
Note: When we stretch a function RANK (RANK) down, the absolute reference ($A$1:$A$9) remains unchanged and the relative reference (A1) changes to A2, A3, A4 etc.
- If the third argument is 1, Excel arranges the numbers in this order: the first number is the smallest, the second is the second smallest, and so on.
=RANK(A1,$A$1:$A$9,1)=РАНГ(A1;$A$1:$A$9;1) - Use the function RANK.AVG (RANK.AVG) to return the mean if multiple values have the same rank.
=RANK.AVG(A1,$A$1:$A$9,1)=РАНГ.СР(A1;$A$1:$A$9;1)