how to compare 2 worksheets in 1 workbook

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

Guest

I'm trying to figure out how to find any difference in 2 (or more) worksheets
in one workbook (file).

These are text files.
 
If you can ensure that both worksheets are in the same sequence by
sorting them using the same column(s), then in a third worksheet you
can enter into A1 a formula like:

=IF(Sheet1!A1=Sheet2!A1,"","different")

This formula can be copied across for as many columns as you have, and
can be copied down for as many rows as you have. Any differences
between the two sheets will be pointed out to you in the appropriate
cell.

Hope this helps.

Pete
 
Back
Top