B4{=IFERROR(INDEX(TRIM(MID(SUBSTITUTE(A$2,"、",REPT(" ",99)),ROW($1:$9)*99-98,99)),SMALL(IF(MMULT(1-ISERR(FIND(TRIM(MID(SUBSTITUTE(B$2,"、",REPT(" ",99)),COLUMN(A:I)*99-98,99)),MID(SUBSTITUTE(A$2,"、",REPT(" ",99)),ROW($1:$9)*99-98,99))),ROW(1:9)^0)<9-LEN(B$2)+LEN(SUBSTITUTE(B$2,"、",)),ROW($1:$9)),ROW(A1))),"")
留言
張貼留言