Thread: How do I eliminate duplicae records in excel file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default How do I eliminate duplicae records in excel file
Hi,
Look here CPearson has a macro to do that, go to the middle of the page

http://www.cpearson.com/excel/deleting.htm



"Big B" wrote:

I have a large excel file with 12K records of companies, addresses., etc I
want to eliminate duplications where company and city are duplicated but not
necessarily street addresses. How do I do so?
Reply With QuoteReply With Quote