compare data in the same column on separate worksheets

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?
 
G

Guest

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
 

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
compare data in 2 worksheets 1
Compare worksheets in two workbooks 1
finding duplicate addresses across 2 worksheets in the same workbo 2
matching & combining data from seperate worksheets 2
Question about Comparing Data 1
How to compare worksheets so differences are identified 1
Compare & highlight changes between two worksheets? 2

Top