# DIFF

#### Syntax <a href="#syntax.13" id="syntax.13"></a>

**DIFF**(*range*; *diffRange*)

* *range* - a range of values - ***Value type**: range with numbers as expected values*
* *diffRange* - a column defining which rows should be removed from range - ***Value type**: column range*
  * all rows of *range* which contain a value which is included in *diffRange* as well are removed.

#### Examples

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