Data Compare-o-Matic – Double Entered Data Comparison in Excel

Data Compare-o-Matic is a simple way to check double-entered data in Microsoft Excel. Double data entry is a technique to guard against data entry errors. Two people enter the same data set into separate documents and the documents are compared for discrepancies in data entry. Data Compare-o-Matic can examine two Excel worksheets and show discrepancies one at a time to the user, who can then either choose the correct value or write-in their own value to correct both data sets. I wrote Data Compare-o-Matic because I couldn’t find a simpler solution for comparing double-entered data in large data sets (i.e. over 100 columns).

Features:

• Easy-to-use interface
• Displays discrepancies individually
• Fix discrepancies with a click
• Write-in your own value to replace values in both tables

Requires:

• Microsoft Excel (with macros enabled)
• Two sets of data arranged in the same order

Watch a video of Data Compare-o-Matic in action!

{ Click to download! }

Download Data Compare-o-Matic!