List.Intersect

Syntax

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

About

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

Example

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

Usage

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

Output

{3, 4, 5}

Related content

Equation criteria