ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to perform a deduplication of names on large mailing list (https://www.excelbanter.com/excel-worksheet-functions/54899-how-perform-deduplication-names-large-mailing-list.html)

IT Assistant

how to perform a deduplication of names on large mailing list
 
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

how to perform a deduplication of names on large mailing list
 
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?



All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com