=LISTUNIQUE
The =LISTUNIQUE() function accepts a semicolon separated text list and returns a list containing only the unique entries from the original list.
Syntax
Section titled “Syntax”=LISTUNIQUE(SemicolonSeparatedList)Parameters
Section titled “Parameters”- SemicolonSeparatedList – The semicolon-separated list of text values to evaluate.
How It Works
Section titled “How It Works”-
Evaluates each item in the list.
-
Removes duplicate entries, so each value appears only once.
-
Returns the resulting list in the order of first occurrence.
Usage Notes
Section titled “Usage Notes”-
Formula functions are case sensitive and must be written in ALL CAPS.
-
Useful for cleaning up lists and ensuring no repeated entries.
Example
Section titled “Example”=LISTUNIQUE(Entry1; Entry2; Entry3; Entry2; Entry3; Entry4)Returns
Entry1; Entry2; Entry3; Entry4
Keywords
Section titled “Keywords”LISTUNIQUE, unique entries, remove duplicates, semicolon-separated list, list processing, workflow formulas, formula function