how do I compare versions of an Excel worksheet

A

Alexa McLaughlin

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
 
M

MartinW

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compare all data in one worksheet to another 1
How do I automatically compare 2 versions of a spreadsheet 1
Excel 2007 pivot table source table 1
How do you convert a pivot table to excel worksheet 2
Send worksheet as HTML email 1
Compare Excel file size 1
Excel 2007 - Pivot Table 2
How do I email an inactive copy of a worksheet 1

Top