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.List Unique Values In A Column 1

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. List Unique Values In A Column 2

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.List Unique Values In A Column 3

An option window will pop-up after this. Set parameters like shown below.List Unique Values In A Column 4

And you will get the result you want:List Unique Values In A Column 5

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 List Unique Values In A Column 6

and click on Remove Duplicates button located on DATA ribbon.List Unique Values In A Column 7

Set parameters like shown below:List Unique Values In A Column 8

When you click on OK button, duplicate values on selected column will be removed and a list of unique values will remain.List Unique Values In A Column 9

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.

You may also like...

Leave a Reply

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