Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Split Excel Table - By Groups

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

 

Back to Tools for Excel Tables Start. See Also List Managers

Split table - 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 Tools for Excel Tables Start

Tools for Excel Tables    Secure Payment Options

Pricing:
1 $89.95 USD
2 - 5 Licenses $79.95 USD
6 - 9 Licenses $72.50 USD
10+ Licenses $54.95 USD

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