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

Excel List Unique Cases of Data

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


Back to Tools for Excel Tables Start

List unique cases  
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.

Back to Tools for Excel Tables Start

Tools for Excel Tables    Secure Payment Options

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