View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
natalia
 
Posts: n/a
Default How do I delete both duplicate rows from a spreadsheet?

I have a spreadsheet of over 10,000 rows, with 3 columns of data. Most lines
in the spreadsheet are duplicates, but there are a few singles here and
there. I need to do a filter to completely remove BOTH duplicate lines so I
am only left with the single records. Is there a way to do this?