Excel

UNIQUE: Excel Formulae Explained

How do you use UNIQUE in Excel?

In Excel, the UNIQUE function takes a range of cells and returns a list of the unique items in that range. This can be useful for identifying duplicate entries in a list, or for finding the unique values in a column of data. The UNIQUE function is case-sensitive, so it will return different results if the text is capitalized differently.

What is the syntax of UNIQUE in Excel?

The syntax of UNIQUE in Excel is as follows:

=UNIQUE(range)

This function will return a list of unique items from the given range.

What is an example of how to use UNIQUE in Excel?

There are a few ways to use UNIQUE in Excel. One way is to use the UNIQUE function, which will return a list of unique items in a given range. Another way is to use the unique function to remove duplicate values from a range. The unique function takes two arguments: the range of cells to be searched and the column index number of the column with the duplicates. The unique function will return a range of cells that contain only unique values.

When should you not use UNIQUE in Excel?

There are a few instances when you should not use UNIQUE in Excel. One instance is when you have duplicate values in your data set. If you use the UNIQUE function on a data set with duplicate values, it will return the first instance of the duplicate value. Another instance when you should not use the UNIQUE function is when you have a text string as your data set. The UNIQUE function will return an error if you try to use it on a text string.

What are some similar formulae to UNIQUE in Excel?

Formula Description =COUNT(DISTINCT(value1,value2,value3,...)

Returns the number of unique items in a given range. =SUM(DISTINCT(value1,value2,value3,...)

Returns the sum of unique items in a given range. =MAX(DISTINCT(value1,value2,value3,...)

Returns the maximum value of unique items in a given range. =MIN(DISTINCT(value1,value2,value3,...)

Returns the minimum value of unique items in a given range.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.