In columns c and d respectively
=EXACT(Sheet1!A1,Sheet2!A1)
=EXACT(Sheet1!B1,Sheet2!B1)

Copy down as needed.

Anything that returns a false means there is a discrepency.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Susan" wrote:

I want to compare for accuracy two coloums of information that should be
identical, but on two different worksheets within the same workbook. So, for
example, I want to make sure that worksheet 1 columns a & b are identical to
worksheet 2 columns a & b, and if not highlight or identify discrepansies.