How can I display only the unique values in one column in Excel?

Is there a way to display the unique values in a column ONLY?

Example:

AAPL
AAPL
AAPL
AAPL
AKAM
AMZN
AMZN
AMZN
AMZN
AMZN
AMZN

Expected result:

AAPL
AKAM
AMZN

I have already done a sort for multiple factors, and the first match for each is the best match.

I’m not sure if this is a vlookup or something else.

Here is Solutions:

We have many solutions to this problem, But we recommend you to use the first solution because it is tested & true solution that will 100% work for you.

Solution 1

Select the data, make sure for a column that you have the first cell as a Label, Use an Advanced Filter and choose Unique Values only. You don’t need to enter any criteria, just hit ok after checking the Unique Value box.

Note: Use and implement solution 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply