Extract items that appear only one time

Extract items that appear only one time
Last Updated on 13/11/2021
Reading time: < 1 minute

How to extract only unique value from a list of data? It's very easy with the UNIQUE function

The UNIQUE function

The UNIQUE function is one of the dynamic arrays functions of Excel 365 or Excel Online.

This function is perfect to remove duplicates from a list a data and very easy to write.

=UNIQUE(A2:A10)

Demo of the UNIQUE function

But in this situation, you extract all the values in the list; the uniques and duplicates values.

Extract only the Unique Values

But you can use the same function to return only unique values by filling the last argument of the function.

In this situation, you just have to fill the 3rd argument; exactly_once = TRUE.

=UNIQUE(A2:A10,,TRUE)

Extract only Unique values

If the 3rd argument = FALSE, you will return exactly the same result as the first example. FALSE is the default value of UNIQUE.

Leave a Reply

Your email address will not be published. Required fields are marked *

Extract items that appear only one time

Reading time: < 1 minute
Last Updated on 13/11/2021

How to extract only unique value from a list of data? It's very easy with the UNIQUE function

The UNIQUE function

The UNIQUE function is one of the dynamic arrays functions of Excel 365 or Excel Online.

This function is perfect to remove duplicates from a list a data and very easy to write.

=UNIQUE(A2:A10)

Demo of the UNIQUE function

But in this situation, you extract all the values in the list; the uniques and duplicates values.

Extract only the Unique Values

But you can use the same function to return only unique values by filling the last argument of the function.

In this situation, you just have to fill the 3rd argument; exactly_once = TRUE.

=UNIQUE(A2:A10,,TRUE)

Extract only Unique values

If the 3rd argument = FALSE, you will return exactly the same result as the first example. FALSE is the default value of UNIQUE.

Leave a Reply

Your email address will not be published. Required fields are marked *