Delete duplicate records from both columns

  • Thread starter Thread starter cantab65
  • Start date Start date
C

cantab65

Hello,

I've got 2 columns of data. How can I delete both records if the appear in
both columns? This is in Excel 2007.

Thanks
 
There may be a cleverer way but to just "get the the job done" you can do the
following:

Put a Vlookup next to each column of data that returns a Y/N flag based on
whether or not there is a match E.g.
=IF(ISNA(VLOOKUP(a1,$d1:$d40,1,FALSE)),"Y","N")

Paste Special Value the results (so that the formula results don't change
once you start the deletions.

Sort the two blocks of data by the Y/N column and delete the two blocks of
"Y"s.

If you want to restore the original order after deleting the matches then
add a third column filled with 1,2, 3 etc) which can be used to resort to
original order after deletions.

If you are a NZer then please advise also.

Cheers,

Matt
 
Back
Top