Get the Unique Values in a Column of Data
Getting the unique values from a column in a dataset is necessary in numerous applications. The example file shows two creative ways to achieve this using the built in Simple Report module (which is intended to group and sum data like a pivot table or aggregation query). However this is an excellent example of when to use VBA and Components to fill in a functional gap in Proto's primitive modules. A pre-built Component called "Get Unique Values" is included in the example file and below.
| 