Returns the rank of a number in a list of numbers.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
RANK(number, ref, [order])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)Результат: 1
Ranks the value in A2 against the range A2:A6 in descending order.
The RANK function assigns the same rank to both numbers, but it will skip the next rank in the sequence.