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:
Output is a single column of unique values from the list.