2

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.

1 Answer 1

5

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.

3
  • amazing..thank you...it worked perfectly. Have a great day, Lance.
    – Lostsoul
    Mar 31, 2011 at 17:22
  • @Lance Roberts Can you explain a bit further ?
    – Happy Bird
    Jan 13, 2018 at 10:35
  • @HappyBird, ok, done. Jan 15, 2018 at 17:06

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .