E2:E10{=IFERROR(IF(ROUNDUP(COUNTIF(B:B,E1)/5,)*(B1<>B$1)=COUNTIF(E$1:E1,E1),"",INDEX({"1班";"2班";"3班"},SMALL(IF(ROUNDUP(COUNTIF(B:B,{"1班";"2班";"3班"})/5,)+1>=COLUMN(A:I),{1;2;3}),ROW(A1)))),"")
F2:J10{=IF($E2="","",INDEX($C:$C,SMALL(IF($B$2:$B$18=$E2,ROW($2:$18),99),COUNTIF($E$2:$E2,$E2)*5-5+COLUMN(A1)))&"")
留言
張貼留言