每次月考都有進步 提取 (12134)

G2:J10{=INDEX(B:B,SMALL(IF(MMULT(N($D$2:$E$16-$C$2:$D$16>0),{1;1})=2,ROW($2:$16),99),ROW(A1)))&""

月考次數多 不可取{=INDEX(B:B,SMALL(IF(($D$2:$D$16>$C$2:$C$16)*($E$2:$E$16>$D$2:$D$16),ROW($2:$16),99),ROW(A1)))&""



留言