how do I remove both duplicate records in excel
 

I have a DBS that is primary and a 2nd one with a list to remove. How do I
combine and delete matching records. Primary is 250K records on several
worksheets, remove lists have maybe 100k total also in smaller groups...

Please help. I have done this before but I have manad a sample DBS and can
not find resolve in testing...

how do I remove both duplicate records in excel
 

Your task is daunting and the results are lkely to be riddled with errors -
some records that shouldn't be deleted get deleted, while not all those that
should be actually are.

Far better to transfer all those records into Access - one big table for the
250K records, and a smaller table for the ones to delete.

Then you run a delete query on the big table, after linking it to the
to-be-deleted table



"Mtgdbsmgr" wrote:

I have a DBS that is primary and a 2nd one with a list to remove. How do I
combine and delete matching records. Primary is 250K records on several
worksheets, remove lists have maybe 100k total also in smaller groups...

Please help. I have done this before but I have manad a sample DBS and can
not find resolve in testing...