c1: if(a1=b1,a1,"")
d1: if(a1=b1,b1,"")

copy down.

This will leave blanks where the dupes are, but there's lots of code
posted here to help you eliminate the blanks.


jellybean wrote:
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!!!!
:(


--
jellybean
------------------------------------------------------------------------
jellybean's Profile: http://www.excelforum.com/member.php...o&userid=37399
View this thread: http://www.excelforum.com/showthread...hreadid=570856