compare data in the same column on separate worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to compare data on 3 separate worksheets but all in same column to see
what data is identical. What is the best technique to use?
 
Hi,

You may try this out. You first compare two worksheetd and then compare the
result with the third worksheet.

For comparing the first two worksheets array enter (Ctrl+Shift+Enter) the
following

=if(or(exact(row 1 of worksheet 1,range of worksheet 2))

This will give you the data that gets repeated on the two sheets.

Now use exactly the same formula to compare the result with the 3 rd. sheet

Regards,

Ashish Mathur
 
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

compare and merge lists in separate worksheets 1
matching & combining data from seperate worksheets 2
Compare worksheets in two workbooks 1
COMPARING TWO COLUMNS OF INFORMATION, ACROSS TWO WORKSHEETS 2
Compare data (2 columns) from 2 worksheets within a workbook 2
Merging Databases 1
compare data in 2 worksheets 1
Retrieve data for previous 3, 6, 12 month given current month 4

Back
Top