Unique List
This article describes the Unique List function and all its properties
Last updated
Was this helpful?
This article describes the Unique List function and all its properties
Last updated
Was this helpful?
The Unique List function can be used to filter through a list of data and returns the unique values from the list, removing duplications.
The Unique List function consists of one property section. Similar to the Data Insertion sections, this section consists of a Series List, Name input, and a Source and Destination input.
The Series list displays all current Unique List series and interactions in the spreadsheet.
The Name input can be manually entered into the field, or bound to a value in the spreadsheet.
The Source and Destination inputs must be bound to ranges in the spreadsheet. If the bound destination range is not large enough, it will fill all available cells and cut off any that do not fit.
Note that the function is case sensitive — any value, though the same word, will be treated as two separate values if there is a difference in any of the letter cases.