Make easy comparisons between data on two spreadsheets. Have the ability to modify the original spreadsheets within the software, including colour formatting. Multi worksheet navigation, navigate easily between any worksheet in either spreadsheet you are comparing. Run simultaneous filters on matching records in two spreadsheets. See the unmatched records between two spreadsheets Use amazing pivot table wizard. Use amazing company name matching tool to find similar company names between two spreadsheets when there are variations in spellings, or when T/A names throw usual vlookups, this software name matching tool looks at similar names and spellings either side of the T/A (trading as) to suggest most likely company name.
What is new in this release:
- Version 1.05 has modifications to the company name matching tool, so it is now possible to update both analysed spreadsheet with replacement company names, and save an excel log of the changes.
- There are some mouseover hints on some of the software controls.
- There is now a search function, that allows typed searches across columns selected in the dropdown menus.
- The pivot table has a function to save, so pivot table worksheets can be saved into new spreadsheets, spreadsheets analysed within the grids, or as new worksheets within existing spreadsheets.
Comments not found