In complex datasets, finding the unique values can sometimes be a bit of a challenge. While you can often simply remove duplicates, if you intend to create a lookup-table, that isn’t an option, and you need to do it differently. Enter the UNIQUE-function.
For this example, assume that you want all unique entries in column A. In this case, simply use the following function in the top cell of a different column: =UNIQUE(A:A)
. In the below example I’ve evaluated eight hundred individual entries and the function returns the forty seven unique ones.
![](https://i0.wp.com/www.razumny.no/wp-content/uploads/image-134.png?resize=413%2C206&ssl=1)
In the coming weeks, I’ll be showing you some practical examples of how I use these kinds of lookup tables.
By posting a comment, you consent to our collecting the information you enter. See privacy policy for more information.