B2=IF(ISERROR(VLOOKUP(A2,$C$2:$C$10,1,0)),"ä¸éå¤","éå¤")
D2=IF(ISERROR(VLOOKUP(C2,$A$2:$A$8,1,0)),"ä¸éå¤","éå¤")
E2=INDEX(A:A,SMALL(IF(COUNTIF($C$2:$C$10,$A$2:$A$8),ROW($A$2:$A$8),4^8),ROW(A1)))&""
ä¸ä¸ªå ¬å¼åä¸å¤å¶
第ä¸ä¸ªæ¯æ°ç»å ¬å¼ãæ°ç»å ¬å¼ï¼å ¬å¼è¾å®åï¼å æ æ¾å¨å ¬å¼ç¼è¾æ åæ¶æä¸CTRL+SHIFT+å车é®ï¼ä½¿æ°ç»å ¬å¼çæã
ä¹å¯ä»¥ä¸ç¨è¿ä¸ªå ¬å¼ææéå¤æä¸éå¤çæ°æ®çéåºæ¥å¤å¶ç²è´´ã