Excel FunctionsLesson 117Free preview

UNIQUE

This lesson is part of Excel · All levels

Summary

UNIQUE is an Excel dynamic array function that returns a list of unique values from a range. The syntax is. This function displays the temporary result through a formula without changing the original data.

Key points

Syntax: UNIQUE(array, [by_col], [exactly_once], [scan_col])
The result is a dynamic array that extends into the surrounding cells.
Exactly_once TRUE displays values that only appear once
Unlike the Remove Duplicates menu that changes the original data

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.