How to find differences between two Excel Spreadsheets - ehMac.ca
Facebook
Twitter
YouTube
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read


Reply
 
LinkBack Thread Tools Display Modes
Old Oct 5th, 2011, 11:48 PM   #1
krs
Honourable Citizen
 
krs's Avatar
 
Join Date: Mar 2005
Location: Ontario and Quebec
Posts: 8,280
How to find differences between two Excel Spreadsheets

I have two Excel spreadsheets (Excel 2004), actually workbooks, but that doesn't matter - I can compare thyem sheet by sheet.

Seems I may have made updates to an earier version not realizing there was already a later version with different updates.

So now I want to find the differences between these two versions to create an update that includes all the changes from the last two versions.

There seem to be lots of Windows applications that do exactly that but for the Mac all I find is workarounds by using MS Word or trying formulas within Excel.

Any simple foolproof fast way to just highlight the differences for the Mac?
krs is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old Oct 6th, 2011, 09:06 AM   #2
Full Citizen
 
Join Date: Jul 2004
Location: Oakville, ON
Posts: 431
Create a third workbook and use the equal operator to compare each corresponding cell; see the following formula:

=[Workbook1]Sheet1!A3=[Workbook2]Sheet1!A3

Use Conditional Formatting to dim the cells containing the value for 'true' since we don't care about these ones. See the attachment below. (I'm using Excel 2011 so the window looks different but the concept is the same.) Any cell that contains the 'false' value will give you a pointer to the changed values.

Before you copy and past the formula, watch out for absolute references ($A$3) which is what Excel will default to if you point and click between the workbooks.

Craig
Attached Images
File Type: jpg Conditional formatting.jpg (42.1 KB, 9 views)

Last edited by WCraig; Oct 6th, 2011 at 09:08 AM. Reason: Excel 2011
WCraig is offline   Reply With Quote
Old Oct 9th, 2011, 12:26 AM   #3
krs
Honourable Citizen
 
krs's Avatar
 
Join Date: Mar 2005
Location: Ontario and Quebec
Posts: 8,280
Thanks for your help Craig.

I don't really feel that comfortable with Excel to try what you suggested.
Tried it on just two of the worksheets, but even with that I'm not sure I have everything set up correctly.

But then, more by luck than anything, I camer across this Excel comparison tool.
Did the job for me:

Compare two Excel spreadsheets without programming macro nor installing software on your computer
krs is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Just lost Excel program...now perplexed mcoltezo Mac, iPhone, iPad and iPod Help & Troubleshooting 5 Jan 3rd, 2008 08:31 PM
Numbers and Excel csonni Anything Mac 3 Oct 28th, 2007 09:52 PM
Rogers' Firefly Bell seek and find Ottawaman Everything Else, eh! 19 Aug 13th, 2005 03:48 PM
Excel starup Mr.Spock Mac, iPhone, iPad and iPod Help & Troubleshooting 5 Mar 17th, 2005 11:01 PM
Excel Macro + File Vault = access problems southside Mac, iPhone, iPad and iPod Help & Troubleshooting 2 Apr 20th, 2004 02:51 PM


All times are GMT -4. The time now is 03:14 AM.



Copyright 1999 - 2012, ehMac.ca All rights reserved. ehMac is not affiliated with Apple Inc. Mac, iPod, iTunes, iPhone, Apple TV are trademarks of Apple Inc. Content Relevant URLs by vBSEO 3.6.0 RC 2

Tribe.ca: Urban living in Toronto!