Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
In Word it's easy to compare two documents, any way of doing it in Excel?
Someone's been using the wrong version of a document, I need to check if he's made any changes... And no, it wasn't me.
Windiff?
I think the simple answer is that there is no simple built in way like in word. If you can handle vba then it isn't too difficult to write something to compare two worksheets (and in fact I see that there is code out there already to do it so you just have to cut and paste)
If you are good for 30 or 40 dollars then you can buy an excel addin to do it.
If the sheet is important, you don't do vba and you are pressed for time - buy the addin.
** This works on 1 cell wide sheets edit **well it did with the office excel guru over my shoulder
get both open
start a 3rd
in top cell of 3 enter if(
then click on top lhs cell of 1
enter =
then click on top lhs cell of 2
enter ,0,1)
if(cellref=cellref, return 0, else return 1)
then copy the formulae all over the 3rd sheet if you see hwt I mean
edit - see here
right its sheet 3 A1 should be set to =IF(Sheet1!A1=Sheet2!A1,0,1)
then repeat the formulae for EVERY cell (**using the correct cell ref)
**you may wish to sort both sheets first ***
Don't know if i'd ever need it but that line is elegant in it's simplicity for a straight comparison.
2 laptops....
gus - genius in it's simplicity, I like
Coot - ya ****in eejit.
[url= http://www.synkronizer.com/ ]http://www.synkronizer.com/[/url] - download the trial version.
or I think there is a plugin for beyond compare, if you already use that?
Dave