D2{=IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(INDEX(SUBSTITUTE(B$2:B$6,"[","["&TEXT(A$2:A$6,"MMDD")),SMALL(IF(LEN(B$2:B$6)-LEN(SUBSTITUTE(B$2:B$6,"[",))>=COLUMN(A:I),ROW($1:$5)),ROW(A1))),"[",REPT(" ",99)),"]",REPT(" ",99)),RIGHT(SMALL(IF(LEN(B$2:B$6)-LEN(SUBSTITUTE(B$2:B$6,"[",))>=COLUMN(A:I),ROW($1:$5)/1%+COLUMN(A:I)),ROW(A1)),2)*198-99,99)),"")
留言
張貼留言