Comparing spreadsheets
David Frick
We have two Excel 5 spreadsheets and would like to compare the two for
differences cell by cell.
Is there an easy way to do this?
Thanks,
Dave
--------
David R. Frick & Co., CPA
http://www.frick-cpa.com
da...@frick-cpa.com
7640...@compuserve.com
Chris Nelson
[posted and emailed]
Assume the following entries in Col. A of Book1:
whenever
wherever
whatever
2
1
=sum(a4:a5) --> 3
And the following entries in Col. A of Book2:
whatever
whenever
wherever
1
2
=sum(a4:a5) --> 3
Then enter the following formula in A1 of Book3:
=IF([Book1]Sheet1!A6=[Book2]Sheet1!A6,"","LOOK!")
Copy the formula wherever you wish on the sheet/s in Book3,
but keep in mind that when you copy from sheet to sheet in
Book3, you will need to manually change the Sheet1
references in the formula, to correspond with the source
sheets. Also keep in mind that calculation time can get
pretty long, so don't copy the whole sheet/s
indiscriminately. Try to be selective.
The word "LOOK!" will highlight every cell by cell
difference. Note that the formula cell above equates in
this case, but WILL NOT equate if the values in Book2 are,
say, 20 and 10 (because the result is different, even
though the formula is the same). You can turn on formula
view if all you want to evaluate is the formula being same
from sheet to sheet.
Hope this helps. Now help us, please, by not crossposting
so much in future.
Chris
David Frick <da...@frick-cpa.com> wrote in article
<#rL2NDkS...@uppssnewspub04.moswest.msn.net>...
David Frick
Thanks for your help Chris.
You politely asked me to help out by "not crossposting so much."
I'm not trying to seem ungrateful but what is wrong with cross posting? In
my case I posted to the 3 groups I thought were most relevant (programming,
worksheet functions, and misc..) This doesn't seem excessive. What is the
problem with posting to more than one group if you're not sure which one is
the most appropriate?
Again, I am not trying to defend actions that cause problems for people. I'm
just not clear on what those problems are.