指定含字母 取出 (14534)

G2:H11{=INDEX(B:B,SMALL(IF(ISERR(FIND($E$2,$B$2:$B$16)),99,ROW($2:$16)),ROW(A1)))&""

J2:K11{=INDEX(B:B,SMALL(IF($E$2=LEFT($B$2:$B$16),ROW($2:$16),99),ROW(A1)))&""



留言