D2:E7{=SUBSTITUTE(INDEX($A:$A,SMALL(IF(1-ISERR(FIND(D$1,$A$1:$A$16)),ROW($1:$16),99),ROW(A1)))&"",D$1&":",)
F2:G7{=IF($D2="","",IF(INDEX(FREQUENCY(IF(1-ISERR(FIND(F$1,$A$1:$A$16)),ROW($1:$16)),IF(1-ISERR(FIND($D$1,$A$1:$A$16)),ROW($1:$16))),ROW(A2)),SUBSTITUTE(INDEX(OFFSET($A$1,MATCH("*"&$D2,$A:$A,),,4),MATCH(F$1&"*",OFFSET($A$1,MATCH("*"&$D2,$A:$A,),,4),)),F$1&":",),""))
留言
張貼留言