remove duplicates but retain one not delete both

D

davidS

I have an excel 2007 list of names, addresses, phone numbers email
addresses etc and there are many duplicate records.
If I sort by postcode for example I can manually delete them but there
are several thousand records and it will be very time consuming.
If I use the excel duplicate delete function it removes BOTH records
instead of letting me keep one.
Additionally, I really need to delete the duplicate record which is
not as complete as the other duplicate.
For example if there are 2 duplicates and one contains email address
and the other does not, then the one WITHOUT the email should be
deleted.
How can I do this pls?
Some function like "search for duplicate records by postcode and
delete 1 record which CONTAINS NULL in row G " ...... something like
that
 

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

Duplicate pst, or is it? 1
Separating Duplicates?? 2
One note creating multiple tabs when collaborating? 0
Have 4 email addresses Want to auto forward all in one of them 0
Deleting duplicates within a column? 0
Formula to Delete Duplicates but keep one record 4
delete duplicates 0
Delete duplicates based on time 1

Top