fx =RANK(A1,$A$1:$A$100,0)ABCJan Score8782.3Feb Score92Mar Score78
📈 Statistical

RANK Formula for Statistical

Rank a value within a range. Copy-paste ready for Excel, Google Sheets, and Airtable.

=RANK(A1,$A$1:$A$100,0)
When you need this: When you have sales figures (A1:A100) and need to rank each salesperson (row 5 scores 45000 → rank them).

How it works

  1. 1The RANK function compares a value (A1) against a range ($A$1:$A$100).
  2. 2Assigns a rank number (1 = highest, 2 = second, etc.).
  3. 3The order parameter (0 = descending, 1 = ascending) determines how to rank.

Variations

Rank in ascending order
=RANK(A1,$A$1:$A$100,1)
Find nth highest value
=LARGE(A1:A100,3)

Related Formulas

AVERAGE — Calculate the average of a rangeStatisticalCOUNTIF — Count cells that meet a conditionStatisticalCOUNTIFS — Count cells meeting multiple conditionsStatisticalMAX / MIN — Find the largest or smallest value in a rangeStatistical

Need a formula that's not here?

Generate custom formula →