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.