Forum Discussion

tyler4321's avatar
tyler4321
Copper Contributor
Apr 17, 2020
Solved

Unique and Sort formulas not showing up on Mac

I know excel has the formulas Unique and Sort because there are how-to articles for them online but I've also seen them working on a windows computer. For some reason, they never show up for me thoug...
Excel on Mac
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Apr 25, 2020

    tyler4321 In Excel on the Mac, press Help in the top menu and "Check for Updates". In the next dialogue, press Advanced...

    Here you can check and change your Update channel.

     

  • tyler4321's avatar
    tyler4321
    Copper Contributor
    Apr 24, 2020

    SergeiBaklan That what I thought too but it never works for me. I have office 360 too. Is there something I can do to check? Or do I need to turn something on? 

     

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Apr 25, 2020

      tyler4321 In Excel on the Mac, press Help in the top menu and "Check for Updates". In the next dialogue, press Advanced...

      Here you can check and change your Update channel.

       

      • tyler4321's avatar
        tyler4321
        Copper Contributor
        Apr 27, 2020
        This worked! I was on production and I switched to insider fast and now I have them! Thank you! I don't know why that worked for me but it did. Thank you so much.
    • tyler4321's avatar
      tyler4321
      Copper Contributor
      Apr 24, 2020
      Excel doesn't even recognize that Unique or Sort is a formula for me.
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Apr 24, 2020

        tyler4321 

        Only Office365 subscription is not enough, you are to be on right channel. If that's semi-annual or like such functions are not available on it so far.

         

        I'm not sure how to check that on Mac.

Resources