A3 下拉 (A3是結果) {=IFERROR(IF(ROW(A1)=1,""," ")&MID($A$1,SMALL(IF(MMULT(N(FIND(MID(TRIM(MID(SUBSTITUTE(A$1," ",REPT(" ",199)),ROW($1:$29)*199-198,199)),{1,2,3},1),TRIM(MID(SUBSTITUTE(A$1," ",REPT(" ",199)),ROW($1:$29)*199-198,199)))={1,2,3}),{1;1;1})=3,ROW($1:$29)),ROW(A1))*4-3,3)&A4,"")
留言
張貼留言