この関数は 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.