Your result in sheet3 is very confusing.
53DFS1I
appears on both sheets, so how come it appears on sheet3 as a missing item?
All sheet 2 lines, except BAMAP2I appear in sheet2. Are you comparing both sheets? Missing items can come only from sheet1(All items of sheet2, except BAMAp2i appear in sheet).
sheet 4 is correct in a sense these two items are missing from sheet1
Re: Compare two worksheets and copy the missing values to sheet 3 (duplicate must be neede
Actually the sheet1 has two columns (A & B), the column A contains the values and column B contains no of Occurrences of "column A" has mentioned in the attached excel sheet:
i want to compare the sheet2 data with sheet1(sheet1 is the master sheet). When compared all the missing values in sheet2 should be copied to sheet3.
Please find the sample sheet attached
Last edited by NAVEEN_1507; 06-07-2013 at 05:34 AM.
Thanks for everyone... I found the solution..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks