Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

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

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