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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.