|
|
|||
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. |
Other Features
Extract 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
Pricing: |
|
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