You could try putting an "X" in the fourth column when there is a duplicate
then go thru the list deleting rows that don't have an "X"

Doug

Matthew in FL wrote in message
...
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.