Forum Discussion

Arron Godfrey's avatar
Arron Godfrey
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 another sheet.  Any suggestions?

 

I have identified the duplicate values and they are now highlighted, but when I try to custom sort by cell colour or by font colour, the system just fails.  I have tried on numerous PCs and also in online excel and on the regular version

 

Thanks

excel

4 Replies

    • Arron Godfrey's avatar
      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's avatar
        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

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Oct 25, 2018

    Hi Arron,

     

    Please follow the below trick which rely on the conditional formatting.

     

Resources