| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Eliminating Duplicate Entries in a Column
I have a mailing list in Excel of 2500 names. After sorting by street address, I see many duplicates. I only need to send to one name at each address. Can anyone suggest a way to automatically delete the multiple addresses without going thru manually?
Thanks in advance! Bob |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
|
Eliminating Duplicate Entries in a Column
Hi Bob,
Am Thu, 11 Sep 2014 01:29:38 -0700 schrieb Guv Bob: I have a mailing list in Excel of 2500 names. After sorting by street address, I see many duplicates. I only need to send to one name at each address. Can anyone suggest a way to automatically delete the multiple addresses without going thru manually? Data = Delete Duplicates or filter your data with Advanced Filter without duplicates Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
|
Eliminating Duplicate Entries in a Column
On 9/11/2014 4:29 AM, Guv Bob wrote:
I have a mailing list in Excel of 2500 names. After sorting by street address, I see many duplicates. I only need to send to one name at each address. Can anyone suggest a way to automatically delete the multiple addresses without going thru manually? Thanks in advance! Bob free ASAP utilities has this function http://www.asap-utilities.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate entries in more than one column | Excel Worksheet Functions | |||
| NO DUPLICATE ENTRIES IN A COLUMN USING EXCEL | Setting up and Configuration of Excel | |||
| Find Duplicate Entries by Column | Excel Programming | |||
| How to remove duplicate entries in column? | Excel Discussion (Misc queries) | |||
| Preventing Duplicate Entries within a column | Excel Discussion (Misc queries) | |||
Linear Mode
