List Unique Values In A Column

Often times you need list unique values in a column to summarize, check or compile results. I will show you three ways to do it fast and easy.

As an example, I am going to use a sample customer data. Goal is to create list of unique city names in column E.

Here is the 3 ways to list unique values in a column:

Using a Pivot Table: All you need to do is to select all values of column E and insert a pivot table. You will have only one field to use. Drag it into “Rows” box and you are done.

Using Advanced Filter: This is pretty easy too. Just select whole column E and copy it. Then click on an empty cell and click on Advanced button located on DATA ribbon.

An option window will pop-up after this. Set parameters like shown below.

And you will get the result you want:

Use Remove Dupicate Values: This method is similar to previous one. Only, this one is faster. Select column E and copy it like you did with second method. This time paste it on an empty column

and click on Remove Duplicates button located on DATA ribbon.

Set parameters like shown below:

When you click on OK button, duplicate values on selected column will be removed and a list of unique values will remain.

If you have other practical wasy to list unique values in a column, leave a comment below the post and we can all benefit from your knowledge.