Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Categorizing Data for Excel

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Categorize Database

BUY |Categorizing DATA FOR Excel Start

Categorize Database

Use this practical tool to categorize records in a database, based on a category table providing up to four category levels.The following example will illustrate how this beneficial tool works: Consider the following database and the (one-level) category table:

Follow these steps:

  • Click on the Categorize button in the toolbar.

  • Choose the database and the field to be evaluated.

  • Select the category table.

  • Finally, choose the destination cell to paste results.

  • The table below shows how the result will be displayed.

Back to Categorizing DATA FOR Excel Start

Other FeaturesExtract unique cases
Test the "stratification table sufficiency"
Stratification 1 to 1
Categorize database
Time stratification
Split field
- Split field - By groups
- Split field - By date
Export sheets as...
Sheets manager
Workbooks manager
Freeze | divide panes
Toggle settings

Categorize Excel Data   $69.95 Secure Payment Options  Instant Buy/Download 30 Day Money Back Guarantee!

1 $69.95 USD
2 - 5 Licenses $64.95 USD
6+ Licenses $59.95 USD

Special ! Free Choice of Complete Excel Training Course OR Excel 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. Send payment proof to [email protected] 31 days after purchase date.

See Also: Excel Add-ins Index & Excel Training Index & Excel Templates Index & Neural Network Software Index Trading Software Index & Charting Software Index Or, All Software

Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft