DISTINCT
Usage
Use this function to get a list of distinct values
| Category | Function | Type | Where to use | Argument statement |
|---|---|---|---|---|
| FUNCTION | SERVER STORAGE | VALUES LIST | .VALUE |
Syntax
1 | |
Arguments
Values_List
any cell value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), constant, System Variables or function-returned values list
Return Value
List
Examples
Example 1
Formula
=DISTINCT(LIST(1; 2; 2; 3))
Description
Return the distinct list of the list 1, 2, 2, 3
Result
1,2,3