> For the complete documentation index, see [llms.txt](https://docs.nedyx.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/unique.md).

# UNIQUE

Removes duplicate rows or columns from a range.

#### 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://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/0XhzVVcFiglxEBqDeaSU/grafik.png" alt=""><figcaption></figcaption></figure>

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

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