Skip to content

Rank values

Give each row its position, with 1 for the highest value.

The formula

Argument separator
Excel and Google Sheets
=RANK.EQ(B2, $B$2:$B$100, 0)

How it works

  1. B2

    The value to rank.

  2. $B$2:$B$100

    All values it is compared with (fixed with $).

  3. 0

    Descending: the largest gets rank 1. Use 1 for ascending.

Example

A: RepB: SalesC: Result
Ana9001
Ben4503
Cleo7002

Tips

  • Ties get the same rank and the next rank is skipped (1, 2, 2, 4).