Leaderboard

Try

=RANK(A6,$A$6:$A$15,1) mean Low Score to High Score. Then next column follow =SUMPRODUCT(($Y$6:$Y$15=Y6)*($AD$6:$AD$15>$AD6))). Then column follow number from 10 to 1. Sheet 2 =IFERROR(VLOOKUP($A6,Sheet1!$A$6:$Y$15,C$1,FALSE),"") from Sheet 1. You see C$1 number is put in 2 in c1 follow next column is 3 in D$1 follow next column E$1 so on so on. Make Job easy to copy across.

Here the file enjoy. Merry Xmas