前名次各班人數 (13964)

G2:I3=SUMPRODUCT((RANK($B$2:$B$21,$B:$B)<=G$1)*($A$2:$A$21=$F2))-SUM($F2:F2)

C2:C21=RANK(B2,B:B)