å设1ï¼ä½ è¿å¼ 表æ¯ç§ä¿¡æ¯é½æ¯ä¸åï¼æ¯ä¸ªå·¥å·å对åºçå
¶ä»ä¿¡æ¯å°±æ¯ä¸è¡ï¼:
å设2ï¼æ¯ä¸ªå·¥å·å¯¹åºçä¸ç§ä¿¡æ¯é½ç¬¦ååªè¦ææç¸åï¼ç¨è¯å°±ä¸å®ç¸åï¼
å设3ï¼åå§æ°æ®å½å
¥çæ¶å没æåçä¸åä¿¡æ¯å½å
¥é误对åºåçæ
åµï¼å¦å°ç±å¥½ä¿¡æ¯å½å
¥å
´è¶£åä¸ã
å½æ»¡è¶³ä»¥ä¸å设ï¼è¯è¯ä»¥ä¸åæ³ï¼
1ãç¨CONCATENATEå½æ°å°è¡¨ä¸(SHEET1)ä¸éè¦æ ¸æ¥çä¿¡æ¯å并æä¿¡æ¯å段ï¼ä¾å¦ï¼H2=CONCATENATEï¼A2ï¼C2ï¼D2ï¼F2ï¼ï¼ç¶åä¸æå®æ第ä¸æ¬¡æ°æ®æ¢ç®
2ãè¿æ¯ç¨CONCATENATEå½æ°å°è¡¨äºï¼SHEET2ï¼ä¸éè¦æ ¸æ¥çä¿¡æ¯å并æä¿¡æ¯å段ï¼ä¾å¦ï¼J2=CONCATENATEï¼A2ï¼C2ï¼E2ï¼G2ï¼ï¼ç¶åä¸æå®æ第äºæ¬¡æ°æ®æ¢ç®
3ãå¨æ°è¡¨(sheet3)A2åå
æ ¼ä¸è¾å
¥å½æ°ï¼A2==IF(Sheet1!H2=Sheet2!J2,"Y","N"),ç¶åä¸æå®ææ°æ®æ ¸å¯¹
4ãå¦æä»»ä¸å·¥ä½è¡¨ä¸çæ°æ®ä¸æ¯ä»¥å·¥å·çç±ä¸è³ä¸æ顺åºæåçè¯ï¼SHEET1çK2åå
æ ¼å½æ°ä¸ºï¼K2=IF(COUNTIF(SHEET2!J$2:J$200,H2)=1,"Y","N")ï¼ç¶åä¸æå®æ第ä¸æ¬¡æ¢ç®
5ã**注æç¹1ï¼ç¨CONCATENATEå½æ°çæ¶åï¼å¿
é¡»å°éè¦æ ¸å¯¹çä¿¡æ¯æç
§ç¸åç顺åºæåï¼ä¾å¦æ°æ®å并顺åºä¸ºâå·¥å·äººåç±å¥½å
´è¶£âã
6ã**注æç¹2ï¼å¦å½æ°è¿ç¨çç»ï¼å¯å°ä»¥ä¸ä¸æ¥è¿ç®å并å¨ä¸ä¸ªåå
æ ¼ä¹è¡ã
ç¥å¥½è¿ï¼
温馨提示:答案为网友推荐,仅供参考