"Cleaning" an Excel workbook

P

Pizza

We are going to be entering data in an Excel spreadsheet, and need to
guarantee accuracy. Our plan is to create two identical spreadsheets, have
two people enter data, then check that they are the same - but how??? By
merging them? Or is there a better way to do this check?
Please help - thanks!
 
S

Svea

One of the simple ways is surely this one:

On the third sheeet write down a formula:
=EXACT(Sheet1!A1;Sheet2!A1)
then copy it through cells in same range as it is in identical sheets.

If it is OJ, formula will return TRUE, if it is not you will ge
FALSE.

hope it will help you
 
P

Pizza

Tried this - but couldn't get it to work - using sheets in one workbook.
However - we will be working on identical sheets in 2 separate workbooks. So
how do we check to assure that the workbooks are identical?
In the meantime, I will play with your formula again. And thank you for
your assistance.
 
S

Svea

Dear Pizza,

Sorry to hear that you couldn't do it with formula I give it to you
=EXACT(Sheet1!A1;Sheet2!A1)

Maybe the problem is, what I noticed, that you should use character ,
instead of ;
So formula would then probably look like this
=EXACT(Sheet1!A1,Sheet2!A1)

I saw many formulas on American web sites and usually I have to change
all , in ;
For you - maybe in other direction. I am from Europe, so there is
possibility that we do not use similar characters for same thing.

Still, I tried to do it with compare.xla that Dave suggested. Works
perfectly!
If you do not now how to "install" Add-ins, ask!

You can find a copy on Chip Pearson's site:
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla
 
P

Pizza

Svea - Thank you for your help!! I downloaded the program that Dave
suggested, and that you also tried, and indeed it was just what I was looking
for! Works like a charm!! I appreciate your help.
 
Top