Exact rows, multiple sheets

  • Thread starter Thread starter jcohen029
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get sheets name without file open 7
Need to merge worksheets - Excel 2003 0
How to filter rows data based on background color of individual cells 1
Format Checking 1
Compare difference between 2 worksheets 2003 1
Compare 2 worksheets 1
how do I update automatically other worksheets in a file 4
Summary Worksheet. 1

Back
Top