What is Excel Compare 3.0.2?
Excel Compare 3.0.2 is a tool that allows you to compare Excel files, Excel spreadsheets and selected ranges of sheets. It can compare data straight from your worksheets, and present the results on a new Excel sheet as a publication-quality report (Difference Report), that is ready to print or save. The report displays the added, deleted and changed data, and highlights the cells that have changed. You can use this tool for analyzing the changes made in your data sets.
What are the features of Excel Compare 3.0.2?
Excel Compare 3.0.2 has the following features:
It supports all versions of Microsoft Excel.
It allows for comparing of sheets that contain a database structure.
It has an advanced comparison algorithm for the data not containing unique identifiers.
It allows for comparing of any selected ranges of a sheet.
It allows for comparing all files located in two different directories.
It allows for comparing all sheets with the same names in two workbooks.
It creates a Difference Report as a new Excel sheet.
It allows for dividing the report into three parts: deleted, added and changed data.
It allows the automatic addition of user-defined macros to the report workbook.
It supports Project settings and Command Line Options.
How to use Excel Compare 3.0.2?
To use Excel Compare 3.0.2, you need to follow these steps:
Download and install Excel Compare 3.0.2 from [this link].
Open Excel Compare 3.0.2 from the Start menu or the desktop shortcut.
Select the sheets to compare from the File menu or the toolbar buttons.
Select the comparison mode and the matching option from the Options menu or the toolbar buttons.
Click on the Compare button or press F5 to start the comparison.
View the results on the new Difference Report sheet that opens automatically.
Save or print the report as needed.
What are some alternatives to Excel Compare 3.0.2?
If you are looking for some alternatives to Excel Compare 3.0.2, you may want to check out these tools:
[Compare Two Sheets]: This is an add-in for Excel that lets you compare two Excel sheets by several key columns and find differences with ease. It offers three comparing modes for different types of worksheets: by key columns, by all columns, and cell by cell. It also allows you to copy or move the differences between sheets, highlight or color them, or add comments.
[Spreadsheet Compare]: This is a tool that comes with Microsoft Office Professional Plus 2013 or Office 365 ProPlus. It lets you compare two workbooks to see the differences between them, line by line. You can see how values, formulas, and formatting differ, and filter or sort the results by different criteria. You can also export the results to a new workbook.
a104e7fe7e