How do I delete dublicate cells?
 

I have a mailing list of over 6000 set up in excel. When I sort by street
adresses I notice that the are quite a few that are duplicated. Is there a
quick way to delete dublicate cells and the lines they rest in?

Hi,
See http://www.cpearson.com/excel/deleting.htm - DeleteDuplicateRows


"Retroactive78" wrote:

I have a mailing list of over 6000 set up in excel. When I sort by street
adresses I notice that the are quite a few that are duplicated. Is there a
quick way to delete dublicate cells and the lines they rest in?