How to compare data in excel

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!
Who is Participating?
ProfessorJimJamConnect With a Mentor Commented:
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 .
Mike in ITConnect With a Mentor IT System AdministratorCommented:
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.
aikimarkConnect With a Mentor Commented:
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:
LadyHagoodAuthor Commented:
Thank you so much.  Worked wonderfully, Professor!
You are welcome LadyHagood. Thanks for the feedback.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.