Deleting Duplicates in Excel - Databases

D

DColeman

I have put my Palm Pilot contacts in Excel. The fields are not all the same
and there are many duplicates. Not all same names are exactly identical. I
want to run a formula that will automatically delete duplicates if just the
names (first and last) are the same. Some info in the rest of the lines may
be different for various reasons. I don't care. Rather just have one entry
for everyone. Does anyone know how to do this?
 
S

SueW

In Excel-Data tab>Data Tools Command Group>Remove Duplicates. Select the
column(s) you have duplicates in and want removed.
 

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

Embedded Excel into Word with Tables 0
Find Duplicate names listed in opposite order 1
Identify Duplicates in a List 1
Copy & Paste Conditional Formatted duplicates w/vba 0
Possible to Combine reports to's to a single box? 0
Counting almost identical duplicates 2
How can the font and size of (all) citation numbers be altered? 1
Embed the same Excel multiple times 0

Top