INTERSECT
Usage
Use this function to get a new set calculated as A ∩ B
Category | Function | Type | Where to use | Argument statement |
---|---|---|---|---|
FUNCTION | SERVER STORAGE | VALUES LIST | .VALUE |
Syntax
1 |
|
Arguments
Parameter_1
any cell value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), constant, System Variables or function-returned values list
Parameter_n
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
=INTERSECT(LIST(1; 2);
=LOOKUPLIST(
#StorageExample;
#StorageExample.Column_1;
#StorageExample.Column_2 = "Approved")
)
Description
...
Result
...