Learn How to Use Microsoft Excel UNIQUE Function

Microsoft Excel UNIQUE Function

The primary function of the Microsoft Excel UNIQUE function is to extract unique values from the range. That implies with the UNIQUE function's help, you can able to return the unique values in the list or range. The values can be numbers, texts, dates, or times, etc.  

Return Value of UNIQUE Function

The return value will be the array of unique values.

Syntax of UNIQUE Function

=UNIQUE(array, [by-col], [exactly-once])

Where the arguments:

array: This is the range or array from which you want to extract the unique values.

by-col: This determine how to compare and extract, by row = FALSE (default), by column = TRUE (optional).

exacly-once: TRUE = values that occur once, FALSE = all unique values, default is FALSE (optional).

How to Use Microsoft Excel UNIQUE Function?

Now we know that the Microsoft Excel UNIQUE function is used to extract a list of unique values from a range or array. The result will be a dynamic array with a unique value. In case this array is the final result, that means not handed off to another function, the array will spill and automatically update if the new unique values are added or removed from the source range.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel