æç¹å¤æ,å¦ææ¯æ两åä¸é½æç人åååºæ¥å°±å¾ç®å,æ两åä¸ä¸éå¤ç人åååºæ¥å°±å¾å¤æ,
æ 论å¦ä½,C1å
¬å¼å¦ä¸:
=IF(ROW()<=SUMPRODUCT(--(COUNTIF(B$1:B$9,A$1:A$10)=0)),INDEX(A:A,SMALL(IF(COUNTIF(B$1:B$9,A$1:A$10),4^8,ROW($1:$10)),ROW())),INDEX(B:B,SMALL(IF(COUNTIF(A$1:A$10,B$1:B$9),4^8,ROW($1:$9)),ROW()-SUMPRODUCT(--(COUNTIF(B$1:B$9,A$1:A$10)=0)))))&""
æ°ç»å
¬å¼ä»¥ctrl+shift+enterä¸é®ç»åç»æè¾å
¥
å
¬å¼ä¸æ
温馨提示:答案为网友推荐,仅供参考