|This tool extracts unique values from a column in a database.
"So that -in a very simple way- we could make category tables (or stratification table), which will allow us to perform a stratified analysis to our database and make better decisions."
The procedure is very simple:
"1. Select a database or just place in any cell in the database (in this case the tool will automatically detect and
select the database in the spreadsheet)"
|2. Click on the Extract unique cases button in the toolbar.
3. The corresponding dialog will appear. Select the field you want to analyze
4. Click OK in the dialog.
|That would be it. A new spreadsheet with unique cases will be created. With this results you may create a stratification table and stratify your database.|
Extract 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
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.