如何将以下两个表中找出单号相同且金额一样的的数据,并用黄色标注出来,
单号 金额 单号 金额
102003720231 1000 102004818542 300
102003720365 1436 102004818551 208
102003720374 296 102004818560 252
102003720383 3000 102004818579 3000
102003720416 1104 102004818588 540
102003720434 580 102003720734 208
102003720522 258 102004818603 300
102003720707 450 102004818612 269
102003720734 208 102004818621 211
102003720752 2000 102004818630 358
102003720822 200 102004818649 239
急急急!!!!
[email protected]
1ãæå¼excelæ°æ®è¡¨æ ¼ï¼å¹¶æé¼ æ æ¾å¨d2 æ ¼ä¸ï¼åé¢çæ¡ä»¶å¼å¡«åäºå 个ï¼å®é å¯ä»¥ä¸åç¾åçå称æåä¸æ ·ã
2ãå¨åè½æ ä¸æ¾å°å ¬å¼ææå ¥å½æ°ï¼éæ©æ¥æ¾ä¸å¼ç¨å¹¶æ¾å°âVLOOKUPâç¡®å®ã
3ãå¨ç¬¬ä¸é¡¹éé¢éæ©B2æ ¼ï¼è¿ä¸ªæ¯åºå®çæ¡ä»¶éæ©é¡¹ï¼ å¨ç¬¬äºé¡¹éé¢éæ©H:Iï¼æ¤é¡¹æ¯éè¦æ ¸å¯¹çæ¡ä»¶æ°å¼ã
4ãå¨ç¬¬ä¸é¡¹éé¢è¾å ¥æ°åâ2â æ¤é¡¹æ¯éæ©å¨ç¬¬äºé¡¹éé¢æè¦å¯¹æ¯ç第å åï¼ç¬¬å项è¾å ¥æ°åâ0â 代表éè¦ç²¾ç¡®å¹é ã
5ãå½æ°ä¿¡æ¯å¡«åå®ç¡®è®¤åï¼è¦æ ¸å¯¹çæ°å¼å°±å¼ç¨å°D2ç±»äºï¼ç¶åç´æ¥ç¨é¼ æ å§D2åä¸æï¼è¯´è¦å¯¹æ¯çæ°å¼å°±é½åºæ¥äºæè æé¼ æ æ¾å¨D2æ ¼å³ä¸è§ å½é¼ æ åæå®ä½ â+âæ¶åå»ä¹å¯ä»¥ã
6ãç¶åæC2å¼åå»D2ï¼ ä¸¤ä¸ªæ°æ®çææå·®å¼ä¸å°±å¯ä»¥å¯¹æ¯åºæ¥äºã