i have 2 columns where i need to extract matched/unmatched values from....
i've tried a few different methods but none seem to be working the way i want it to because of the duplicate values (the problem is that these are "legitimate" duplicates)....which is making me question whether it's even possible?!?!?!![]()
example - if value in column A exists in column B, then remove from both columns
A B
1 0
1 1
1 2
2 2
3 3
3 3
desired result:
A B
1 0
1 2
i've tried an excel add-on called DigDB....however, it will give me "matched" results regardless of how many there are (i.e. it will tell me all the values = 1 and values = 2 are matched eventhough there are more in one column than the other)...
i tried vlookup but again, the dups create a problem for me...(unless someone can provide me with a multiple vlookup statement for this?)....
pls help...i don't want to resort to doing this in multiple layers!!!!![]()
Bookmarks