View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default eliminate duplicates on a sheet

see:

http://www.cpearson.com/excel/Duplicates.aspx


--
Gary''s Student - gsnu201001


"C. Brown" wrote:

I have a list of 3500 names & addresses in an Excel workbook on one sheet and
some are duplicates. How do I eliminate duplicates?