What is RANK?
Returns the rank of a number within a list. Essential for leaderboards, performance rankings, and competitive analysis.
Syntax
=RANK(number, ref, [order])
Example
Formula: =RANK(A2, $A$2:$A$20)
Result: Position in ranking
How It Works
Returns position of A2 within the range. Default ranks largest as 1. Use order=1 for ascending (smallest=1).