關鍵詞提取 二種方式 (15146)

C2:E4{=INDEX($G:$G,RIGHT(SMALL(IF(ISNUMBER(FIND($G$2:$G$9,$A2))*($G$2:$G$9>0),FIND($G$2:$G$9,$A2)/1%+ROW($2:$9),999),COLUMN(A1)),2))&""

C8:E10{=INDEX($G:$G,SMALL(IF(ISNUMBER(FIND($G$2:$G$9,$A2))*($G$2:$G$9>0),ROW($2:$9),99),COLUMN(A1)))&""