How to Get Distinct values in a column in Excel 2016 ?

This blog post will explain in simple steps on how to get the unique or distinct values in a column in Microsoft Excel 2016.

Assume that you have a column (A) in excel worksheet that contains values and you want to find out what distinct values are present in the column. You can follow the below steps to get the unique values from the column.

How to Get Distinct values in a column in Excel 2016 ?

1. Select the complete column for which you want to find the distinct values.

2. Navigate to the Data Ribbon and click the "Advanced button" which is found in the "Sort & Filter" group.

image

3. You will be prompted with a warning message. Click OK. In the Advanced Filter Dialog box , select the radio button "copy to another location" and enable the checkbox "Unique records only" and click OK.

image

4. Immediately , you would see the results shown in the selected "copy to" cells.

Leave a Reply