Thread: How do I remove all records of duplicated fields?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nozzaworld nozzaworld is offline
external usenet poster
  
Posts: 8
Default How do I remove all records of duplicated fields?
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 appreciated.

Many thanks

--
nozzaworld
Reply With QuoteReply With Quote