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.
Other FeaturesExtract unique cases
Test the "stratification table sufficiency"
Stratification 1 to 1
- Split field - By groups
- Split field - By date
Export sheets as...
Freeze | divide panes
Categorize Excel Data $69.95 Secure Payment Options Instant Buy/Download 30 Day Money Back Guarantee!
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
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