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.
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.
If the 3rd argument = FALSE, you will return exactly the same result as the first example. FALSE is the default value of UNIQUE.