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

"john mcmichael" wrote:

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?