Excel distinct values formula

Unique values are those that appear on a list just once.

Excel get distinct values from column in another sheet

When working with data in Excel, you will often come across datasets that have duplicates in the column and you will have to extract the unique values or items from that columns

In fact, it is one of the most common data cleaning tasks, as it helps remove duplicates, thereby saving memory space as well as processing time.

More importantly, by removing redundancy, it keeps the data organized and makes it easier to make inferences.

In this tutorial we will show you three ways to get unique values from a column in Excel:

• Using the Remove Duplicates tool
• Using the Advanced Filter tool
• Using the UNIQUE function (Excel 365 and later versions)

We will demonstrate each of the above methods by applying them to the following list of names:

Notice that the name John Smith appears three times in the above list, and the name Manuel Braun appears twice.

So our aim here would be to only extract the unique names from this list (no repetitions).

Let’s see some simple ways to do this in Excel.

Using the Exc

how to display distinct values in excel

how to show distinct values in excel pivot table