Is there a way to display the unique values in a column ONLY?
AAPL AAPL AAPL AAPL AKAM AMZN AMZN AMZN AMZN AMZN AMZN
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.
Here is Solutions:
We have many solutions to this problem, But we recommend you to use the first solution because it is tested & true solution that will 100% work for you.
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.
Note: Use and implement solution 1 because this method fully tested our system.
Thank you 🙂