Solved

How to compare data in excel

Posted on 2016-11-28
5
27 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 3

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

758 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

18 Experts available now in Live!

Get 1:1 Help Now