è§æªå¾
D1è¾å ¥
=INDEX(B:B,SMALL(IF(ISNUMBER(FIND(C$1,B$1:B$100)),ROW($1:$100),200),ROW(A1)))&""
æ°ç»å ¬å¼ï¼å æä½CTRL+SHIFT,æåå车
å ¬å¼ä¸æ
追é®è¿æ¯æ²¡è¾¾å°éæ±ï¼å®é ä¸Båå ¨é¨æ¯æåæè¿°ï¼C1æ¯ä¸ªååï¼æ³è¿åBåä¸æææå ³C1ååæè¿°çä¿¡æ¯ã