å设âå称âãâéé¢âé½åå«å¨AãBåï¼ç¬¬ä¸è¡æ¯æ é¢ï¼æ°æ®ä»ç¬¬äºè¡èµ·ï¼
å¨è¡¨ä¸çC2è¾å
¥
=IF(COUNTIF(表äº!A:A,A2)=0,"ä¸ç¸å","")
æ
=IF(COUNTIF(表äº!A:A,A2)=0,A2,"")
å车并åä¸å¡«å
ï¼ä¸æï¼
æ¾ç¤ºâä¸ç¸åâçå°±æ¯è¡¨ä¸å½ä¸Aåâå称âå¨è¡¨äºéé¢æ²¡æç¸åçäºã
åéCåââèåæ ââæ°æ®ââçéââèªå¨çéââç¹åâ²ä¸æéï¼ä¸ç¸åï¼ã
åæ ·ï¼è¡¨äºéé¢ä¹è®¸æå¨è¡¨ä¸å½ä¸æ²¡æç¸åçï¼ä¹è¦ç¨å
¬å¼âæ¾âåºæ¥ï¼
å¨è¡¨äºçC2è¾å
¥
=IF(COUNTIF(表ä¸!A:A,A2)=0,"ä¸ç¸å","")
å车并åä¸å¡«å
ã
温馨提示:答案为网友推荐,仅供参考