總和前名次取出 註記不計 (13925)

H2{=IF(ROW(A1)>F$2,"",INDEX(B:B,RIGHT(LARGE((MATCH(B$2:B$21,B:B,)=ROW($2:$21))*SUMIFS(C:C,B:B,B$2:B$21,D:D,"<>V")/1%+ROW($2:$21),ROW(A1)),2)))

I2=IF(H2="","",SUMIFS(C:C,B:B,H2,D:D,"<>V"))