compare data in the same column on separate worksheets

J

john mcmichael

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

Ashish Mathur

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
 
Top