Solved

How to compare data in excel

Posted on 2016-11-28
5
74 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 26

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 7

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 26

Expert Comment

by:ProfessorJimJam
ID: 41904639
You are welcome LadyHagood. Thanks for the feedback.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

809 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