hi,
i have a list in column "a and b" in sheet 1 and a list in sheet 2 column "a and b" as well, the rows range vary
i would to get the data from sheet1 that is not in sheet 2 and copy it in to sheet 3
Please see attached excel.
I have not been able to find a match using vlookup, countif , productsum...see row A2 and B2 they have the same exact name and amount on both sheets
The last thing I tried to do was a simple find and replace and I found out that the excel is not able any "text" matches.????
thanks
Bookmarks