|
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. | ||||
|
feedback
|
This question came from our site for professional and enthusiast programmers.
|
Use an Advanced Filter and choose Unique Values only. | |||
|
feedback
|
|
Build a pivot table on top of your data. | |||
|
feedback
|
