Excel: Finding unique values

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.

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.

This site uses Akismet to reduce spam. Learn how your comment data is processed.