If your problem consists in categorizing or stratifying specific data of your Excel spreadsheet information, then Categorizing Data for Excel is the solution.
This product is an addin for Microsoft Excel that, allows you:
- Categorizing records in a database, based on a category table.
- Extracting unique values from a column in a database and building another table with that data.
- Stratifying time by: years, months, weeks and inclusive days lapsed.
- Making stratification based in a correspondence one-to-one.
- Knowing if a particular table is well designed, using "stratification table sufficiency" tool.
- Separating a column in its different parts o categories.
- And more...
In this new version 1.1 of Categorizing Data for Excel: - You can consolidate ranges - It is completely compatible with Excel 2007
If you acquire Categorizing Data for Excel you can upgrade to Excel Model Builder or Model Assistant Suite paying only the difference.