INTERSECTION
Returns elements of a range which are included in another range as well.
Returns elements of a range which are included in another range as well.
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
