| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I compare versions of an Excel worksheet
I have a worksheet file (of contacts information) from 1998 and another from
2006 which are the same size (25kb). I now need to update the data. I suspect there's no change in the data between the two versions, just a change in the way I have coded file names, but I need to be sure. Is there an equivalent in Excel 2007 to Word 2007's "Compare" in the Review tab? Alexa |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I compare versions of an Excel worksheet
Hi Alexa,
Maybe this, Say you have two sheets in one file Sheet1 and Sheet2. Then place this formula in A1 of Sheet3 and drag across and then down as far as needed. =IF(Sheet1!A1=Sheet2!A1,"",1) A one will show wherever there is a difference. You can adapt the same principle to compare from workbook to workbook, just adapt the references. Or you can copy the sheets into the same workbook. HTH Martin "Alexa McLaughlin" wrote in message ... I have a worksheet file (of contacts information) from 1998 and another from 2006 which are the same size (25kb). I now need to update the data. I suspect there's no change in the data between the two versions, just a change in the way I have coded file names, but I need to be sure. Is there an equivalent in Excel 2007 to Word 2007's "Compare" in the Review tab? Alexa |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I compare versions of an Excel worksheet
Dear Martin
Many thanks. It worked a treat. Alexa "MartinW" wrote: Hi Alexa, Maybe this, Say you have two sheets in one file Sheet1 and Sheet2. Then place this formula in A1 of Sheet3 and drag across and then down as far as needed. =IF(Sheet1!A1=Sheet2!A1,"",1) A one will show wherever there is a difference. You can adapt the same principle to compare from workbook to workbook, just adapt the references. Or you can copy the sheets into the same workbook. HTH Martin "Alexa McLaughlin" wrote in message ... I have a worksheet file (of contacts information) from 1998 and another from 2006 which are the same size (25kb). I now need to update the data. I suspect there's no change in the data between the two versions, just a change in the way I have coded file names, but I need to be sure. Is there an equivalent in Excel 2007 to Word 2007's "Compare" in the Review tab? Alexa |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I compare versions of an Excel worksheet
Glad it helped Alexa, thank you for posting back.
Martin "Alexa McLaughlin" wrote in message ... Dear Martin Many thanks. It worked a treat. Alexa "MartinW" wrote: Hi Alexa, Maybe this, Say you have two sheets in one file Sheet1 and Sheet2. Then place this formula in A1 of Sheet3 and drag across and then down as far as needed. =IF(Sheet1!A1=Sheet2!A1,"",1) A one will show wherever there is a difference. You can adapt the same principle to compare from workbook to workbook, just adapt the references. Or you can copy the sheets into the same workbook. HTH Martin "Alexa McLaughlin" wrote in message ... I have a worksheet file (of contacts information) from 1998 and another from 2006 which are the same size (25kb). I now need to update the data. I suspect there's no change in the data between the two versions, just a change in the way I have coded file names, but I need to be sure. Is there an equivalent in Excel 2007 to Word 2007's "Compare" in the Review tab? Alexa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare two versions of an excel document? | Excel Discussion (Misc queries) | |||
| Shared Worksheet Mixed versions 2003/2007 | Excel Worksheet Functions | |||
| 2 versions of the same worksheet *.xls:1 & *.xls:2 - Why ? | Excel Worksheet Functions | |||
| Saving worksheet so that merge cells work in previous versions | Excel Worksheet Functions | |||
| Please include fonts from previous versions ('98) in new versions | Excel Discussion (Misc queries) | |||
Linear Mode
