Diff EngineX is a utility that finds the differences between the formulae, constants, defined names (named ranges) and cell comments contained in either two whole Excel workbooks or selected worksheets.
It generates a cell-by-cell difference report in a new spreadsheet and color highlights different cells in automatically made copies of your workbooks.
As Excel worksheets get modified over time new rows and columns can be inserted between existing ones. DiffEngineX can align similar rows and columns in the sheets being compared. It has many powerful features such as the ability to hide matching rows, group like changes to adjacent cells, highlight differences at the character level and ignore small numeric differences (or differences below a user-specified value).
DiffEngineX can also compare databases (prior sorting may be required for rows of data) and comma separated value (CSV) files once they have been imported into Excel.
Click here to find out more.