Examples

INTERSECT(LIST("Red", "Blue", "Green"), LIST("Orange", "Blue")) returns a list with one item: Blue. See also: LIST().

INTERSECT(Employees[Name], LIST("Bob")) returns a list of one item, Bob, if that name occurs in the list of employee names. Equivalent to IFS(IN("Bob", Employees[Name], LIST("Bob")). See also: IFS(), IN().

INTERSECT(Employees[Name], Employees[Name]) returns a list of unique names in the Employees[Name] column. Equivalent to UNIQUE(Employees[Name]). See also: UNIQUE().

Syntax

INTERSECT( list1 , list2 )

Arguments

list1, list2 (Lists of comparable types): the two lists in which to find common elements.

Return Value

List of items common to both list1 and list2.

See Also

ANY(), COUNT(), IN(), LIST(), MAX(), MIN(), SORT(), UNIQUE()

Did this answer your question?