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?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
861984648930060324
true
Search Help Center
true
true
true
false
false