排序 及格人数对应班级，从多到少 (9838)

E4:E7{=IFERROR(INDEX(A:A,RIGHT(LARGE(IF(MATCH(A$2:A$14,A$2:A$14,)=ROW($1:$13),COUNTIFS(A:A,A$2:A$14,B:B,"及格")/1%+ROW($2:$14)),ROW(A1)),2)),"")

另解 {=IFERROR(LOOKUP(1,0/(MAX(COUNTIFS(A:A,A$2:A$14,B:B,"及格")*(COUNTIF(E$3:E3,A$2:A$14)=0))=COUNTIFS(A:A,A$2:A$14,B:B,"及格")),A$2:A$14),"")