View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default How can I get rid of duplicates in a column?

See:

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


--
Gary''s Student - gsnu200836


"trainer07" wrote:

I have a column of loan numbers. This column contains duplicated loan
numbers. I want to get rid of all the duplicates without having to go thru
each one and manually deleting the entire row. Any suggestions? THanks