INTERSECTION

Returns elements of a range which are included in another range as well.

Syntax

INTERSECTION(range; intersectRange)

• range - the range where elements should be removed - Value type: any

• intersectRange - the range defining which elements remain in range - Value type: any

The function returns a copy of range, where only these elements remain which are included in intersectRange as well. All other cells are empty.

Examples