Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I find differences between two open excel files
I'm trying to determine the differences and changes made between two
different files to capture that the correct changes were processed |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I find differences between two open excel files
It depends on what you're looking for.
This may help if you want to compare two worksheets and do a cell by cell comparison (A1 with A1, x99 with x99, ...) http://www.cpearson.com/excel/whatsnew.aspx look for compare.xla Gary wrote: I'm trying to determine the differences and changes made between two different files to capture that the correct changes were processed -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I find differences between two open excel files
Much of this depends on how the data is laid out, whether the data is
in the same order, etc. Are the files essentially the same number of columns and rows, but one is more up-to-date than the other? The answers to these questions determine how to proceed. DaveO Eschew Obfuscation |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I find differences between two open excel files
I think I can offer a partial solution. You can identify what cells have
changed or, if numeric how much the change is. Your original files are file1 & file2. Create a new file (file3). If all the values are numeric: In file3 A1 subtract file1 A1 from file2 A1. Go to Tools Options View tab and uncheck Zero values. If the cells are not numeric: In file3 A1 =(IF(file1 A1=file2 A1),"","Changed") In each case the changed cells will be obvious, either with Changed or the difference between the values. This will only work if the changes have not altered the layout of the sheet (ie not inserted or removed cells). Ian "Gary" wrote in message ... I'm trying to determine the differences and changes made between two different files to capture that the correct changes were processed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the differences in 2 columns | Excel Discussion (Misc queries) | |||
How do I find the differences in two spreadsheets | Excel Discussion (Misc queries) | |||
i couldn't open my excel files,it gives location couldn't find err | Excel Discussion (Misc queries) | |||
Find differences between two Excel workbooks or worksheets | Excel Discussion (Misc queries) | |||
How do I find differences between two excel worksheets? | New Users to Excel |