hi all, i m in need of help regarding finding the differences between four columns i.e. RECEIPT No & AMT. in sheet1 and RECEIPT No & AMT in sheet2.i would like to know the Formula which will highlight the differences between the two columns in both sheets.
Receipt No Total Paid Receipt No Total Paid 1151886 490 1151886 490 1151882 2100 1151882 2100 1151883 50 1151883 50 1151881 3500 1151881 1500 1151880 4000 1151881 2000 1151894 710 1151880 800 1151894 490 1151880 1200 1151894 710 1151894 490 For example the RECEIPT no:1151881=3500 is splitted into two in the second worksheet.as 1151881=1500 & 2000.In short i need to lookup the Receipt No with the amount in worksheet one with the Receipt no with the amount in worksheet two.i need only THOSE receipt no and Amounts which are different.. Please guide me... thanks & regards.... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
