Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"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! |
#2
|
|||
|
|||
"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 |
#3
|
|||
|
|||
"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 |
#4
|
|||
|
|||
"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 |
#5
|
|||
|
|||
"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 |
#6
|
|||
|
|||
"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 |
#7
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 - Why does 1 workbook open as 2 versions | Excel Discussion (Misc queries) | |||
Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Can a workbook be opened w/out Excel on the host machine?? | Excel Discussion (Misc queries) | |||
Why does Excel 2003 freeze when saving a workbook that has importe | Excel Worksheet Functions |