Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
filter 400 names from list 1 from list 2 with 4000 names | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
How do I put a list of names and e-mail addresses in excel so tha. | Excel Discussion (Misc queries) |