Workbook Inconsistency Check

[DrRock]

I have two individuals entering data from my research into two separate workbooks. What is the best way to check for inconsistencies between the books. I.E., I would like to know which cells have been entered incorrectly.

Thank you

 

[mole999]

what would be inconsistent, and without a third reference, which would be wrong. Potentially, the two files can be imported by a master and then checked to see which cells didn't match, then obviously you have to get them identified and rectified

 

[DrRock]

The third reference is a handwritten sheet the two aides are entering data from. I thought if I could see the cells that differed, I could go to the sheet and determine which is correct.

 

[DrRock]

I thought this would be an easy one.

 

[DrRock]

Bump

 

[Willmonbo]

you can simply do an If statement like :

=IF([book1]sheet1!A1=A1,"","Inconsistent")

you would obviously need to modify formula with the actual references.

I hope this helps.

 

[DrRock]

Thank you for the reply. I thought of using if statements coupled with some conditional formatting to identify the errors. The problem is that we have dozens of columns of data across about 30 sheets, which would require 30Xdozens of if statements. It is certainly doable, and better than manually checking, but it is less than ideal.

This is my current solution unless anyone can think of anything better.

Thanks again!

 

[DrRock]

Bumpity Bumpity.