(先)G2:H8{=OFFSET(A$1,SMALL(IF(LEN($D$2:$D$4)-LEN(SUBSTITUTE($D$2:$D$4,"/",))+1>=COLUMN($A:$I),{1;2;3},99),ROW(A1)),)&""
(中)J2:J8{=IF(G2="","",TRIM(MID(SUBSTITUTE(T(OFFSET(D$1,SMALL(IF(LEN(D$2:D$4)-LEN(SUBSTITUTE(D$2:D$4,"/",))+1>=COLUMN(A:I),{1;2;3}),ROW(D1)),)),"/",REPT(" ",99)),RIGHT(SMALL(IF(LEN(D$2:D$4)-LEN(SUBSTITUTE(D$2:D$4,"/",))+1>=COLUMN(A:I),{1;2;3}/1%+COLUMN(A:I)),ROW(D1)),2)*99-98,99)))
(後)I2:I8=IF(G2="","",IFERROR(MID(J2,FIND(" ",J2)+1,9),OFFSET(C$1,SMALL(IF(LEN(D$2:D$4)-LEN(SUBSTITUTE(D$2:D$4,"/",))+1>=COLUMN(A:I),{1;2;3}),ROW(A1)),)))
留言
張貼留言