分數大於40且分數排序 取學生 (13215)

取不重複 A11{=IFERROR(INDIRECT(TEXT(MIN(IF((COUNTIF(A$10:A10,B$2:E$7)=0)*(B$2:E$7<>""),ROW($2:$7)/1%+COLUMN(B:E))),"!R0C00"),),"")

B11:D16{=INDEX($A:$A,RIGHT(LARGE(IF(($B$2:$E$7=$A11)*($F$2:$I$7>40),$F$2:$I$7/1%+ROW($2:$7),99),COLUMN(A1)),2))&""