> For the complete documentation index, see [llms.txt](https://enable-advisory-1.gitbook.io/the-way-we-work/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://enable-advisory-1.gitbook.io/the-way-we-work/microsoft-excel/unique.md).

# UNIQUE

**Syntax:**

\=UNIQUE(array, \[by\_col], \[exactly\_once])

**Explanation:**

* *array* - Range or array from which to extract unique values.
* *by\_col* - \[optional] How to compare and extract. By row = FALSE (default); by column = TRUE.
* *exactly\_once* - \[optional] TRUE = values that occur once, FALSE= all unique values (default).

**Example:**

![](https://1421118769-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MdtjvomCsvuXz1wFFAA%2Fuploads%2Fk0OINHJu9JYL0hJt9vOb%2Fimage.png?alt=media\&token=35fb735d-5057-427e-aa6c-2446bfeace4b)

![](https://1421118769-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MdtjvomCsvuXz1wFFAA%2Fuploads%2F5kDVyNRvbWaI46tv83ZV%2Fimage.png?alt=media\&token=bbb5839a-aba8-4b9b-a94b-b8e48e580783)

**Notes:**

The Excel UNIQUE function extracts a list of unique values from a range or array. The result is a dynamic array of unique values. If this array is the final result (i.e. not handed off to another function), array values will "spill" onto the worksheet into a range that automatically updates when **new uniques values are added or removed from the source range**.