how to perform a deduplication of names on large mailing list

[IT Assistant]

I have a list of over 8000 names and addresses and other information, and I
need to eliminate duplicates, it there a eaiser way to do this action verses
manual?

[William Horton]

You could use Excel's advanced filter functionality. Click a cell in the
list and then follow the Excel menu path Data / Filter / Advanced Filter.
Then click the unique records only box and click OK (you can adjust other
criteria if you like). This should give you only unique / non duplicate
entries in your list range.

You can also check out Chuck Pearson's site on duplicates.
http://www.cpearson.com/excel/duplicat.htm

Hope this helps.

Bill Horton

"IT Assistant" wrote:

> I have a list of over 8000 names and addresses and other information, and I
> need to eliminate duplicates, it there a eaiser way to do this action verses
> manual?