이 함수는 Google Sheets에서도 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.