按比例分别记分 (10111)

 

C2=LOOKUP(RANK(B2,B:B),SUBTOTAL(9,OFFSET(E$1,,,{1,2,3}))*2+1%%,F$2:F$4)

G2=COUNTIF(C:C,F2)

另解 C2=INDEX(F$2:F$4,MATCH(1=1,PERCENTRANK(B$2:B$21,B2)>=ROUNDDOWN((20-SUBTOTAL(9,OFFSET(E$2,,,{1,2,3}))*2)/(20-1),2),))