彙整老師的學生 (12953)

J3:11{=IFERROR(INDIRECT(TEXT(SMALL(IF(($B$5:$B$16="姓名")*($C$5:$H$16<>"")*(IF($C$3:$H$3="",$B$3:$G$3,$C$3:$H$3)=J$1),ROW($5:$16)/1%+COLUMN($C:$H)),ROW(A1)),"!R0C00"),),"")