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