How do I find duplicate rows in a list in Excel, and not delete it

[Guest]

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.

 

[olasa]

This is one option:
=COUNTIF($A$4:$A$18,A4)>1
copy down, and use a Autofilter to find all True

HTH
Ola Sandström

Picture encl.:
http://www.excelforum.com/attachment.php?attachmentid=3498&stc=1


+-------------------------------------------------------------------+
|Filename: Clipboard01.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3498 |
+-------------------------------------------------------------------+

 

[Doug]

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