Forum Discussion

Copper Contributor

Oct 25, 2018

Removing unique values

Hello everyone I hope someone can help me. What I am trying to do is remove all of the unique values from a spreadsheet. Or alternatively, remove the duplicates but for them to be saved into an...

excel

Arron Godfrey

Copper Contributor

Oct 26, 2018

Thank you so much for this. I can't seem to get the arrow to appear next to where it says 'values' at the top?

Thanks

Haytham Amairah

Silver Contributor

Oct 26, 2018

Hi Arron,

This is the https://support.office.com/en-us/article/Use-AutoFilter-to-filter-your-data-7D87D63E-EBD0-424B-8106-E2AB61133D92 arrow.

To activate it, select the Values column, then click Data > Filter or press Ctrl+Shift+L.

Hope that helps