Prev: tab to next unlocked cell
Next: using VBA to retrieve values to ComboBox
From: cantab65 on 18 Mar 2010 21:31
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
From: Matt Geare on 19 Mar 2010 01:45
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

"cantab65" wrote:

> 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
From: Herbert Seidenberg on 19 Mar 2010 14:15
Excel 2007
Advanced Filter
http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_19_10a.xlsx
Pdf preview:
http://www.mediafire.com/file/jjwmkngeinv/03_19_10a.pdf
 | 
Pages: 1
Prev: tab to next unlocked cell
Next: using VBA to retrieve values to ComboBox