1ï¼å·¥èµè¡¨å并å¨ä¸ä¸ªè¡¨
å·¥èµè¡¨Aãå·¥èµè¡¨B åæ¶å并å¨ä¸ä¸ªè¡¨ä¸ï¼è¡¨åæ¹ä¸ºï¼å·¥èµè¡¨
2ãèå¤è¡¨å并å¨ä¸ä¸ªè¡¨
èå¤è¡¨Aãèå¤è¡¨B åæ¶å并å¨ä¸ä¸ªè¡¨ä¸ï¼è¡¨åæ¹ä¸º:èå¤è¡¨
=IF(COUNTIF(å·¥èµè¡¨!A:A,èå¤è¡¨!A2)>=1,"å¨","ä¸å¨")
å¨èå¤è¡¨ä¸æåºï¼å°æ¾ç¤ºâä¸å¨âçå
¨é¨å é¤
3ãæåºèå¤è¡¨é¡ºåº
å¨èå¤è¡¨æä½: =MATCH(èå¤è¡¨!A2,å·¥èµè¡¨!A:A,0),å¾åºå¯¹åºå·¥èµè¡¨ä¸çå§ååºå·ï¼è¿è¡æåºï¼å¾åºä¸å·¥èµè¡¨ä¸åæ ·åºå·ä¸ä½ç½®çèå¤è¡¨ã
温馨提示:答案为网友推荐,仅供参考