Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I automatically compare 2 versions of a spreadsheet
I need to compare a previous spreadsheet with the current spreadsheet
automatically (200 rows x 30 columns) to see what has changed between versions. How can I do this easily. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I automatically compare 2 versions of a spreadsheet
Hi,
try one of these two methods 1 In Sheet1, enter: =IF(ISNA(MATCH(C1,Sheet2!C:C,0)),"yes","") 2 create a third spreadsheet and enter =exact( click on first spreadsheet and select the first cell you are comparing. click on third spreadsheet and enter , click on second spreadsheet and select the first cell you are comparing. click on third spreadsheet and enter ) then hit the enter key. Select that cell you just made and highlight down and to the right and hit control r then hit control d hope this helps "Mz2832" wrote: I need to compare a previous spreadsheet with the current spreadsheet automatically (200 rows x 30 columns) to see what has changed between versions. How can I do this easily. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare two versions of the same spreadsheet to see diff. | Excel Discussion (Misc queries) | |||
how do I compare versions of an Excel worksheet | Excel Discussion (Misc queries) | |||
How do I compare two versions of an excel document? | Excel Discussion (Misc queries) | |||
I open a spreadsheet and get multiple versions - why? | Excel Discussion (Misc queries) | |||
multiple versions of a spreadsheet | Excel Discussion (Misc queries) |