You can do this either with a formula or a macro. the easiest way is to
create an auxilary column with the results. Then use Autofilter to get the
rows that match. finally perform a copy and paste. Used this formula in
Colmn E

=IF(SUMPRODUCT(--(A1=A$1:A$1000),--(B1=B$1:B$1000),--(C1=C$1:C$1000))1,TRUE,FALSE)

Copy formula down the auxilary column

"Pawan" wrote:

Hello...

I have a worksheet with thousands of row and several columns. There are
three important columns , say A, B and C. If data in these three columns is
repeated (duplicated), then I have to sort these rows. e.g.

A B C D E
John NY 25 M JK
Lisa NY 29 F JK
John NY 25 M IN

In the above case, Row 1 and 3 has duplicated values in columns A, B and C
(difeerent values in other columns doesnt matter). I have to find out such
'duplicated rows' and I want to generate a list of such rows in a separate
worksheet.
Is it possible? Any help is highly appreciated.

Thank You

Regards,
Pawan