Exact rows, multiple sheets

J

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.
 
M

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
 
Top