View Single Post
  #1   Report Post  
Matthew in FL
 
Posts: n/a
Default How do I find duplicate rows in a list in Excel, and not delete it

I have a long list of data in Excel that is 3 columns wide. I need to find
and save only the duplicate rows but don't want to delete them. Instead, I
could delete the unique rows and keep the duplicate rows. In the customer
assistance, I found out how to delete duplicate rows and save the unique
rows, but this is exactly opposite of what I want to do.