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 1

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}

Equation criteria