/
INTERSECTION
INTERSECTION
Syntax
INTERSECTION(<list>;<list>;...)
Description
Returns the intersection of all list arguments. The resulting list contains only the elements found in all the list arguments and doesn't contain any duplicate elements.
Example
INTERSECTION(Column1;Column2;Column3;Column4)
Column1 | Column2 | Column3 | Column4 | INTERSECTION returns |
---|---|---|---|---|
[1, 2, 3, 4] | [3, 4, 5] | [1, 2, 3, 4, 5] | [3, 3, 4, 4] | [3, 4] |
, multiple selections available,
Related content
INTERSECTION
INTERSECTION
More like this
INTERSECTION
INTERSECTION
More like this
REMOVEALL
REMOVEALL
More like this
REMOVEALL
REMOVEALL
More like this
REMOVEALL
REMOVEALL
More like this
UNIQUES
UNIQUES
More like this