Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete duplicate records from both columns
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete duplicate records from both columns
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete duplicate records from both columns
Excel 2007
Advanced Filter http://c0718892.cdn.cloudfiles.racks...03_19_10a.xlsx Pdf preview: http://www.mediafire.com/file/jjwmkngeinv/03_19_10a.pdf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete all duplicate records - without keeping one of them | Excel Worksheet Functions | |||
Delete records when certain records have duplicate column data | New Users to Excel | |||
Compare and delete duplicate records | Excel Worksheet Functions | |||
Delete Duplicate records | Excel Worksheet Functions | |||
how to delete duplicate records in a row | Setting up and Configuration of Excel |