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.

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...tid=3498&stc=1


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

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=379019

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.