各科最高分班级 姓名 (9192)

O11:P15{=OFFSET($C$1,RIGHT(MAX(($D$1:$H$1=$N11)*$D$2:$H$25/1%+ROW($1:$24)),2),1-COLUMN(A1))

O2:O6=SUMPRODUCT((C$2:C$25=N2)*(OFFSET($C2:$C25,,LOOKUP(1,0/FIND(D$1:H$1,N$1),{1,2,3,4,5}))>=110))

Q2:Q6=SUMPRODUCT((C$2:C$25=P2)*(I$2:I$25>=LARGE(I$2:I$25,10)))

另解O2:O6=COUNTIFS(C:C,N2,H:H,">"&110)

另解Q2:Q6=COUNTIFS(C:C,P2,J:J,"<="&10)