View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chris
 
Posts: n/a
Default deleting duplicate names

I have an excel spreadsheet with over 19,000 contacts. Some are duplicates
(Contact) and I would like delete them.
The columns across the top are as follows:
Company/Contact/Phone1/Zip/Address/City/Acct Manager/Record Type

Can someone please write a macro, or tell me how to delete the duplicates
for Column B?