| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you de-dup an address list in Excel?
I'm trying to automate the deduplication of an address list in Excel.
-- Jim Agnew |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you de-dup an address list in Excel?
Hi
Look at the "Advanced Filter" on the data menu and select "unique only". Hopes this helps --- Per "Jim Agnew -- Canada" skrev i meddelelsen ... I'm trying to automate the deduplication of an address list in Excel. -- Jim Agnew |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you de-dup an address list in Excel?
Hi,
In 2007 choose the list and then the command Data, Remove Duplicates - a nice new feature! In 2003 use advanced filter as mentioned in the previous post, then select the results and copy them somewhere else. The delete the original list. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Jim Agnew -- Canada" wrote: I'm trying to automate the deduplication of an address list in Excel. -- Jim Agnew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Word address list to Excel | Excel Discussion (Misc queries) | |||
| excel list of names, addresses and email to address book/contact list??? | Excel Discussion (Misc queries) | |||
| Address List in Excel | Excel Discussion (Misc queries) | |||
| HOW DO I MAKE ADDRESS LABELS OUT OF LIST IN EXCEL DOC? | Excel Discussion (Misc queries) | |||
| long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) | |||
Linear Mode
