A small correction for my requirement please.... i need to highlight those receipt nos which had different amounts..Verma bhayya...formula ko change karona please taaki,Receipt nos with different amounts highlight hue to color kardena....
thanks a lot for the help.... On Thu, May 3, 2012 at 12:21 AM, Mr excel <excelkeec...@gmail.com> wrote: > thanks for the speedy reply sir..how about using VBA for finding the > differences between the columns and pasting them(only the DIFFERENT > ones-Receipt no & amount which are not matched to a new sheet one down the > other... > > > On Thu, May 3, 2012 at 12:08 AM, Mr excel <excelkeec...@gmail.com> wrote: > >> 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 >> > > -- 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