This Intuitive Analytics video describes the Unique function in SmartModels™ Utilities.
It’s a well-known problem that you can’t easily create a unique list of elements from a long range of cells with duplicate entries. No formula exists for this and the user is left either writing some code to try and get it done or potentially a large manual task.
Unique in SmartModels™ Utilities makes this a snap:
- Enter the range with duplicate entries.
- Click the Unique button.
- Inspect your results in the column next to your input range.
Output is a single column of unique values from the list.
BENEFITS
- Speed - Generate a unique list in three clicks.
- Flexibility - Works for both numeric and text values.
- Speed, again - Input ranges are set and stored in the interface until the user changes it, saving additional time when data changes and recalculation is necessary.