# UNIQUE

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

**UNIQUE**(*range*; *orientation*)

* *range* - the range from which the duplicates are removed - ***Value type**: range*
* *orientation* - the orientation in which the duplicates are removed - ***Value type**: constant (optional, <mark style="color:red;">vertical</mark> as default).*\
  Possible values are:
  * *<mark style="color:red;">horizontal</mark>* - duplicate columns are removed
  * *<mark style="color:red;">vertical</mark>* - duplicate rows 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-7128cc214ed03fb567b6c744d3d80485c51a824f%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-5af965defeb402cef29660c18b80ed38a112f988%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-beacaeae80a993b2b3aba18bcd230d1a4502be75%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>