View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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