Four teams scored 96, 87, 87 and 80 in B2:B5. Two teams share second place. If your standings need a single winner at each rank, agree on a tiebreaker before publishing.

Lock the comparison range before filling down

In C2 use =RANK(B2,$B$2:$B$5,0) and fill through C5. Verify 1, 2, 2 and 4. The absolute range keeps the comparison group fixed while B2 advances to each row.

Scores 96, 87, 87 and 80 get ranks 1, 2, 2 and 4.

Illustrated standings. The next position after a tie counts both tied rows.

Change the direction as a control

Use 1 for the last argument to put smaller values first, as with an elapsed time. These same inputs should then rank 4, 2, 2 and 1. If two displayed values appear tied but rank differently, show more decimals to check their underlying precision.

Using the same values with ascending order gives ranks 4, 2, 2 and 1.

Illustrated direction check. The lowest value becomes first.

Related Microsoft Excel reference