Skip to main content

List.Intersect

Returns the intersection of the list values found in the input.

Syntax

List.Intersect(
lists as list,
optional equationCriteria as any
) as list

Remarks

Returns the intersection of the list values found in the input list lists. An optional parameter, equationCriteria, can be specified.

Examples

Example #1

Find the intersection of the lists {1..5}, {2..6}, {3..7}.

List.Intersect({{1..5}, {2..6}, {3..7}})

Result:

{3, 4, 5}

Category

List.Set operations