2 workbooks - eliminating dulplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Lets say I have two excel files and need to eliminate the dulicates in one
file. How do I do that.

I'm trying to import a list of new contacts into act. First I'm exporting
the act database to act.xls. I also have newcontacts.xls. I'd like to prune
the duplicates out of newcontacts.xls so I can them import only fresh
contacts to act without duplicate contact errors.
 
Assuming by "duplicates" you mean that all columns are identical in the two
records, just open the 2nd file, copy the records to the bottom of the
existing list in the 1st file. Then Data/Filter/Advanced Filter, and select
the Unique Records option. If you Filter in Place, you can then inspect what
you have and copy the records to another location. Or you can copy to another
location directly from the Filter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple Methods to Export Gmail to Text? 1
Delete duplicate and original entries in excel 3
How do I eliminate duplicae records in excel file 1
Removing Duplicates to another sheet 1
How do I merge my BCM 2003 database with my Outlook 2003 database? 1
Modifying Data 1
Outlook Business Contact Manager 4
Import Multiple CSV Files from Same Folder into Open Workbook 5

Back
Top