Thread: delete all dulplicate rows leaving no record of the duplicates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nozzaworld nozzaworld is offline
external usenet poster
  
Posts: 8
Default delete all dulplicate rows leaving no record of the duplicates
I am using excel 2002. I have a row of data, with some duplicated records. I
want to be able to delete ALL duplicates.

e.g.
bob
bob
scott
john

would delete all record of bob leaving just the following:

scott
john

How can I achieve this? Any help will be greatly apprenciated.

Many thanks

--
nozzaworld
Reply With QuoteReply With Quote