A13:N16{=OFFSET($A$1,SMALL(IF($C$2:$C$9=SMALL(IF(MATCH($C$2:$C$9,$C:$C,)=ROW($2:$9),$C$2:$C$9),INT(COLUMN(E1)/5)),ROW($1:$8),99),ROW(A1)),MOD(COLUMN(E1),5))&""
休假日C13:C16改{=IFERROR(OFFSET($A$1,SMALL(IF($C$2:$C$9=SMALL(IF(MATCH($C$2:$C$9,$C:$C,)=ROW($2:$9),$C$2:$C$9),INT(COLUMN(G1)/5)),ROW($1:$8)),ROW(C1)),MOD(COLUMN(G1),5)),"")
C13:C16複製到H13:H16 M13:M16
留言
張貼留言