Categorize Database in Excel
Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS
Back to Tools for Excel Tables Start
Categorize database Use this practical tool to categorize records in a database, based on a category table.
It also provides as much as four category levels.
The following example will illustrate how this beneficial tool works:
Consider the following database and the (one-level) category table:
Follow the following steps:
Click on the Categorize button in the toolbar, then:
1. Choose the database and the field to be evaluated.
2. Select the category table.
3. Finally, choose the destination cell to paste results.
4. The table below shows how the result will be displayed.
Besides, You can use the added field to create a pivot table.
In the image below showed an example
Back to Tools for Excel Tables Start
Pricing:
1 $89.95 USD 2 - 5 Licenses $79.95 USD 6 - 9 Licenses $72.50 USD 10+ Licenses $54.95 USD Tools for Excel Tables Secure Payment Options
Free Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site.
Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
>
Contact Us