Save hours comparing, analyzing, and fixing information in Excel. With a few clicks you can compare sheets, ranges, tables, and all kinds of lists and line-of-business data, all without having to enter complex formulas. Quickly analyze the compare results with color coded cell-by-cell differences, data filters, and difference counts. Find added, removed, and duplicate rows in lists. Optionally, merge the differences into a new list of corrected or up-to-date information.
Compare and Merge can benefit a wide spectrum of users. For casual users, those possibly not comfortable with formulas and formatting, Compare and Merge can be used to quickly find differences and fix monthly reports, time sheets, and more. If you're a Department Administrator, for example, Compare and Merge can save you hours with repetitive tasks such as maintaining employee, customer, and various other lists. For financial services professionals, such as Accountants and Financial Analysts, Compare and Merge can help with your financial analysis and reporting spreadsheets. For technical and advanced Excel users, Compare and Merge is a great tool for data analysis and cleansing scenarios or by QA professionals for comparing baseline data to new/evolving data during development.
Select Methods are what make Compare and Merge different from other add-ins and apps. Select Methods provide innovative ways to get data into the compare ranges, data you may not even think is possible to compare. For example, using the Filtered Table Select Method you can compare data in the same table but with different column filters applied to the compare ranges. Select Methods can also automatically find the compare ranges for you. For example, the Current Date to Previous Select Method will automatically find and compare ranges based on sheet names ending with a certain date pattern such as "Sales Q1 2016" and "Sales Q4 2015".
Try Compare and Merge for 15 days using the "Free Trial" button.
Watch the Getting Started video: http://www.strivetech.com/appvideos/ExcelCompareAndMerge
Learn more: http://www.strivetech.com/Apps/ExcelCompareAndMergeHelp
Compare and Merge Feature Summary:
NOTE: Compare and Merge is available in Excel 2016 or later and Excel Online.