Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |