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.