The **UNIQUE** function in Excel is designed to return a list of unique values from a specified range or array. This is particularly useful when you need to remove duplicates or identify distinct items from a dataset.

<div style="display: flex; justify-content: center;">
=UNIQUE(array,&nbsp;[by_col],&nbsp;[exactly_once])
</div>

| | |
|---------------|----------------------------------------------------------------------------------------------|
| array | The range or array from which to extract unique values. |
| [by_col] | (Optional) A logical value indicating whether to compare values by row or by column. The default is **FALSE** (compare by row). |
| [exactly_once] | (Optional) A logical value that returns values that occur exactly once in the range or array. The default is **FALSE** (include all unique values). |

Let's start with a simple example. Suppose you have a list of names in column A, and you want to extract the unique names. Write this formula and give it a range of values and excel will do the heavy work for us.

The **UNIQUE** function can also be used to extract unique rows from a dataset. And you can create a formula that will return only the unique rows from the specified range.

What does the exactly_once argument do when set to TRUE?

This course is designed for beginners who want to start exploring formulas in Excel. You'll begin with the basics and then discover some really useful formulas for daily use. You'll learn about array formulas and how they work, and you'll also dive into Lookup and Reference functions.

In this section you will learn how to input and use Excel formulas for various calculations, including basic operations like addition, subtraction, multiplication, division, and power. Discover the importance of using functions for clearer and more efficient calculations. Explore statistical functions like AVERAGE, MEDIAN, MODE, MIN, and MAX to analyze data effectively.

In this section you will learn about array formulas in Excel and how they enable multiple calculations on sets of values simultaneously and how to use specific functions like UNIQUE, SORT, FILTER, and TRANSPOSE.

In this section, you will learn about lookup and reference formulas in Excel. These formulas enable you to search for and retrieve specific data from a table or range. You will explore essential functions such as VLOOKUP, HLOOKUP, MATCH, INDEX, and XLOOKUP, which are invaluable for finding and referencing data efficiently.


array	The range or array from which to extract unique values.
[by_col]	(Optional) A logical value indicating whether to compare values by row or by column. The default is FALSE (compare by row).
[exactly_once]	(Optional) A logical value that returns values that occur exactly once in the range or array. The default is FALSE (include all unique values).

Excel Formulas

UNIQUE