D2:I11{=INDEX($B:$B,SMALL(IF(1-ISERR(0/(FIND(D$1,$B$2:$B$21)=1)),ROW($2:$21),4^8),ROW(A1)))&""
另解{=INDEX($B:$B,SMALL(IF(ISNUMBER(FIND("|"&D$1,"|"&$B$2:$B$21)),ROW($2:$21),4^8),ROW(A1)))&""
另解{=INDEX($B:$B,SMALL(IF(FIND(D$1,$B$2:$B$21&D$1)=1,ROW($2:$21),4^8),ROW(A1)))&""
留言
張貼留言