Formula or Method for Deleting Duplicate Entries?

[Guest]

My office manager just asked me to post a question to this group......

She is creating a spreadsheet for our agency "Mailing List", and wanted to
know if there was a formula or method for detecting possible "dual entries"
and deleting the older entry. Unfortunately she is grabbing the information
for the Mailing List from multiple sources, and "dual entries" are very
possible.

Thank you in advance,

Dan

 

[Guest]

Matching names (and addresses) can be tricky as it often difficult to get an
exact match; for example one source might include middle initial while
another doesn't so a simple match won't work.

So to a degree it depends on the likely variability of the data.

Take a look here for some ideas:

http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique