Solved

MS Excel file comparison

Posted on 2014-03-31
7
220 Views
Last Modified: 2014-04-07
Hello,
I searched the internet and looked at Excel, yet could not find how I would be able to compare two Excel files.
The way I did this the last time, was to convert the excel file to a word/text file, then I was able to use Word to compare the two.  I am searching for a direct way, comparing excel file to excel file.  Maybe there are other ways?
thanks
0
Comment
Question by:chima
  • 3
  • 3
7 Comments
 
LVL 30

Expert Comment

by:captain
ID: 39968069
This really depends on your objective. Do you want to compare excel files for differences or do you want to compare data?

If it is the latter you can have a third sheet looking at 2 sheets and run a formula across the sheet such as
=if(worksheet1!A1=worksheet2!A1,1,0)

This will return a "1" when the data is the same and a "0" if it isn't. You can then have conditional format to highlight any 0 in red and locate differences.
0
 

Author Comment

by:chima
ID: 39968236
captain, I see how the formula would work.  I think each Excel file will be different and it would take a lot of effort to create the formulas for each cell.  I'll keep this in mind.

slightwv, I do not agree you removing it from the Oracle zone.  An Expert there might have had knowledge or an idea to share with me.  And if there weren't anyone, then no one would have responded.
0
 
LVL 30

Expert Comment

by:captain
ID: 39968667
If you work on an empty 3rd sheet you simply copy the formula across all cells by dragging it. Of course this depends on the layout of the sheets that you compare being equal and just data being different.

You can ignore the 1s which will also appear on empty cells anyway and the 0s will highlight quickly any differences.

If the layout of your files is different then you have no way of comparing automatically without writing special formulas conditional to each.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:chima
ID: 39969769
captain, allow me time to look at what you wrote and I will get back to you.  thanks
0
 
LVL 30

Accepted Solution

by:
captain earned 500 total points
ID: 39972961
No problem, if you have a sample file with dummy data please share.
0
 

Author Closing Comment

by:chima
ID: 39983625
thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now