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.

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.

Illustrated direction check. The lowest value becomes first.



