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

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

>