Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Mar 31 '11 at 17:16

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 1 down vote accepted

Use an Advanced Filter and choose Unique Values only.

share|improve this answer
    
amazing..thank you...it worked perfectly. Have a great day, Lance. –  Lostsoul Mar 31 '11 at 17:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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