Forum Discussion

ruixuan's avatar
ruixuan
Copper Contributor
Sep 24, 2022

UNIQUE function not avaliable

My Excel license shows that I have subscribed to Microsoft 365, but I couldn't use some functions such as UNIQUE, it doesn't appear automatically when I type, and I get the wrong result when I press enter.

If that matters, I downloaded it from my school's official website and signed in with a .edu Email address.

excel
Excel on Mac
Formulas and Functions

6 Replies

  • DexterG_III's avatar
    DexterG_III
    Iron Contributor
    Sep 24, 2022

    ruixuan What build are you on?  

     

    When they first rolled out dynamic arrays, you needed to be a part of the office insider program & in the Beta Channel.  If you click on File/Account do you see this?  

     

     

    • ruixuan's avatar
      ruixuan
      Copper Contributor
      Sep 24, 2022
      I use MacOS and couldn't find the exact page you shared (it seems like a screenshot on Windows). Although I did find it said Version 16.65(22091101) if that's the information you need.
      • DexterG_III's avatar
        DexterG_III
        Iron Contributor
        Sep 24, 2022

        ruixuan Okay I'm not familiar with the mac application but have provided a couple links which may help you.  

         

        https://answers.microsoft.com/en-us/msoffice/forum/all/dynamic-array-formulas-excel-for-mac/129e9644-ad71-4ded-a6aa-057b4212c354

         

        https://www.groovypost.com/howto/join-microsoft-office-insider-program-mac-os-x/

         

        Dexter 

         

Resources