INTERSECT

Syntax

=INTERSECT(array1, array2)

Examples

=INTERSECT([1, 2, 3], [3, 4, 5])→[3]
=INTERSECT(["A", "B"], [1, 2])→\[]
=INTERSECT([OBJECT("A", 1), OBJECT("B", 2), OBJECT("A", 1, "B", 2)], [OBJECT("A", 1), OBJECT("B", 2)])→[{"A": 1}, {"B": 2}]