Exact rows, multiple sheets

[jcohen029]

I need to compare two sheets one workbook. I need to know which rows are the same in Sheets1 and Sheets2 with 14 columns of information to compare? There are about 8000 rows in each sheet.

[mangesh_yadav]

In sheet3, simply enter
=IF(Sheet1!A1=Sheet2!A1,Sheet1!A1=Sheet2!A1,"")
or
=IF(Sheet1!A1=Sheet2!A1,Sheet1!A1,"")
and copy to the lenght and breadth of sheet1

This will put TRUE when there is a match, and a blank otherwise.
The second formula puts the actual value instead of a TRUE.

Mangesh