"Cleaning" an Excel workbook
 

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!

"Cleaning" an Excel workbook
 

If you mean cell by cell comparison (a1 with a1, x99 with x99), you can use a
program written by Myrna Larson and Bill Manville.

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



Pizza wrote:

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!

--

Dave Peterson

"Cleaning" an Excel workbook
 

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 get
FALSE.

hope it will help you.


--
Svea
------------------------------------------------------------------------
Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151
View this thread: http://www.excelforum.com/showthread...hreadid=477625

"Cleaning" an Excel workbook
 

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.

"Svea" wrote:


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 get
FALSE.

hope it will help you.


--
Svea
------------------------------------------------------------------------
Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151
View this thread: http://www.excelforum.com/showthread...hreadid=477625

"Cleaning" an Excel workbook
 

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


--
Svea
------------------------------------------------------------------------
Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151
View this thread: http://www.excelforum.com/showthread...hreadid=477625

"Cleaning" an Excel workbook
 

Thank you, Dave!! Works perfectly!!

"Dave Peterson" wrote:

If you mean cell by cell comparison (a1 with a1, x99 with x99), you can use a
program written by Myrna Larson and Bill Manville.

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



Pizza wrote:

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!

--

Dave Peterson

"Cleaning" an Excel workbook
 

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.

"Svea" wrote:


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


--
Svea
------------------------------------------------------------------------
Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151
View this thread: http://www.excelforum.com/showthread...hreadid=477625