彙整上下學期為同行 (15283)

G3:I8=INDEX(A:A,MIN(IF(COUNTIF($H$2:$H2,$B$2:$B$8)=0,ROW($2:$8),99)))&""

J3:K8{=INDEX($E:$E,MIN(IF(($B$2:$B$8=$H3)*($D$2:$D$8=J$2),ROW($2:$8),99)))&""