Comparing worksheets

  • Thread starter Thread starter Spartan
  • Start date Start date
S

Spartan

I have seen that there are already other discussions regarding this and
I have gone through quite a few but couldn't quite make sense of it or
use the assistance provided there.

I have two worksheets. They have multiple columns and I need to compare
the two sheets to look for any data thats missing in either sheet or
any row that has different info for an employee and then highlight
where the difference is arising. Can anyone help about me with this?
Thanks in advance.
 
Spartan said:
I have seen that there are already other discussions regarding this and
I have gone through quite a few but couldn't quite make sense of it or
use the assistance provided there.

I have two worksheets. They have multiple columns and I need to compare
the two sheets to look for any data thats missing in either sheet or
any row that has different info for an employee and then highlight
where the difference is arising. Can anyone help about me with this?
Thanks in advance.
Click to expand...

You can use COUNTIF to compare them, in a helper column next to the
column you're looking for. If the fields are always in the same order,
you can make a string out of all of the fields such as =A1&B1&C1&D2 to
make a combined field. Then make the same string on the other sheet,
and use countif on each sheet to compare it to the field on the other
sheet. Where you have 1, it's on the other sheet. Where threre are 0s,
it's not on the other sheet.
 
Back
Top