# 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://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-e7aa69be546c2360799db5103db46eb71f2d912d%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-83ea54fdf2f75f1a55a51aaa8b0ceebea23cbc4f%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-320406e416349c8bbd9d09cc721a99cfc6a7ff28%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>