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? |
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