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 specifed.

Example 1

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

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