View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pat Jones Pat Jones is offline
external usenet poster
 
Posts: 6
Default finding duplicate cell and deleting both

Hi;

I have about 8000 cells of which 800 are duplicates. I want to find all the
dupes and delete BOTH copies of them. Can that be done and if so, how ?


Thanks;

Pat