# INTERSECTION

#### 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**

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/WVd2ttLwmBt4lg6cKRxT/grafik.png" alt=""><figcaption></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/yudjBg4MDOSx8zHurXue/grafik.png" alt=""><figcaption></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/0fQyXJYbgdfcegNvyrXI/grafik.png" alt=""><figcaption></figcaption></figure>