How do I eliminate duplicae records in excel file

[Big B]

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?

 

[Eduardo]

Hi,
Look here CPearson has a macro to do that, go to the middle of the page

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