Spilt Field - By Groups
Microsoft Excel - From Beginner to Expert in 6 Hours
/ EXCEL DASHBOARD REPORTS
Back to Categorizing Excel Data Start
Split field - By groups Use Split field by groups to split a database in multiple data groups, according to repeated values in the selected field.
For example: Say your database is the selected area and the selected field is Category. Click OK.
Notice that several sheets with the expected results have been created.
This tool is very simple to use, but very helpful.
Back to Categorizing Excel Data Start
Categorize Excel Data
![]()
Secure Payment Options
Pricing:
1 $59.95 USD 2 - 5 Licenses $50.95 USD 6 - 9 Licenses $44.95 USD 10+ Licenses $29.95 USD 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 settingsFree 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