INTERSECT()

Items common to two lists

Returns a list of items common to two lists.

Sample usage

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)

  • list1, list2 - Two lists of comparable types in which to find common elements.

See also

ANY()

COUNT()

IN()

LIST()

MAX()

MIN()

SORT()

UNIQUE()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false