为æææçï¼åå¨åä¸å¼ 表ä¸ï¼ä¸åç表ï¼å ä¸å·¥ä½è¡¨åå³å¯
详è§æ ·è¡¨æªå¾
F2è¾å ¥
=INDEX(A:A,SMALL(IF(COUNTIF($E$2:$E$4,$A$2:$A$11),ROW($2:$11),100),ROW(A1)))&""
æ°ç»å ¬å¼ï¼å æä½CTRL+SHIFT,æåå车ï¼ä½¿å¾ç¼è¾æ å ¬å¼ä¸¤ç«¯åºç°è±æ¬å·{ }
å ¬å¼å³æåä¸æå°æ æ°æ®