Rank scores in column B descending. Tied scores should share a rank and skip the next number

公式

=RANK(B2, $B$2:$B$100, 0)

说明

RANK (or RANK.EQ) gives competition ranking: two 1sts, next is 3rd. Use RANK.AVG if ties should share 1.5. Lock the full list so each row compares to the same field.

步骤

  1. 0 as the third argument ranks largest = 1.
  2. Lock $B$2:$B$100.
  3. Copy down next to every score.

变体

Average rank for ties

Two tied leaders both get 1.5; the next unique score is 3.

=RANK.AVG(B2, $B$2:$B$100, 0)

Unique rank (no shared ties)

Breaks ties by who appears first in the list.

=RANK(B2, $B$2:$B$100, 0)+COUNTIF($B$2:B2, B2)-1

Percentile rank

Returns 0–1. Format as % for a leaderboard percentile.

=PERCENTRANK.INC($B$2:$B$100, B2)