如题所述
æ¯å¦Båä¸ç¼ºå°Aåçåå
D2è¾å ¥
=INDEX(A:A,SMALL(IF(COUNTIF(B:B,A$2:A$100),6^6,ROW($2:$100)),ROW(A1)))&""
åæ¶æä¸CTRL+SHIFT+Enterä¸é®ï¼ä½¿æ°ç»å ¬å¼åºç°{ }ï¼å ¬å¼ä¸æå°ç©ºå¼