各校各科前30%人數 (9566)

G2:H4=SUMPRODUCT(($B$2:$B$21=$F2)*(C$2:C$21>=LARGE(C$2:C$21,(COUNTA($A:$A)-1)*30%)))

格式化 C2:D21=C2>=LARGE(C$2:C$21,6)