Solved

How to compare data in excel

Posted on 2016-11-28
5
51 Views
Last Modified: 2016-11-28
Hi Everyone,
I'm need to compare two very large data outputs that are in excel.  they are currently in two separate workbooks but are set up the same with regards to columns, etc.  I need to quickly identify the difference.  

Thank you in advance!
0
Comment
Question by:LadyHagood
5 Comments
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 250 total points
ID: 41904236
If you have excel 2013 or 2016 then you can use built in addin called "Inquire" found under comm addins

If you have earlier version of excel then you cannot find any better software other than excel synchronizer .
0
 
LVL 6

Assisted Solution

by:Mike in IT
Mike in IT earned 125 total points
ID: 41904351
As the Professor said, if you have Excel 2013 or higher, you can use "Inquire" to compare the 2 workbooks.

Some of the pertinent info:

Compare two workbooks

The Compare Files command lets you see the differences, cell by cell, between two workbooks. You need to have two workbooks open in Excel to run this command.

Results are color coded by the kind of content, such as entered values, formulas, named ranges, and formats. There's even a window that can show VBA code changes line by line. Differences between cells are shown in an easy to read grid layout.

The Compare Files command uses Microsoft Spreadsheet Compare to compare the two files. In Windows 8, you can start Spreadsheet Compare outside of Excel by clicking Spreadsheet Compare on the Apps screen. In Windows 7, click the Windows Start button and then > All Programs > Microsoft Office 2013 > Office 2013 Tools > Spreadsheet Compare 2013.

To learn more about Spreadsheet Compare and comparing files, read Compare two versions of a workbook.
0
 
LVL 45

Assisted Solution

by:aikimark
aikimark earned 125 total points
ID: 41904570
Do you need to compare just the data differences (assuming these are tables) or differences in the cell property values?

You can do a worksheet comparison very similarly to the way I did a CSV comparison using ADODB in this question thread:
https://www.experts-exchange.com/questions/28938199/Compare-line-percentage-change-in-CSV-files.html#a41540992
0
 

Author Closing Comment

by:LadyHagood
ID: 41904613
Thank you so much.  Worked wonderfully, Professor!
0
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 41904639
You are welcome LadyHagood. Thanks for the feedback.
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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

920 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

15 Experts available now in Live!

Get 1:1 Help Now