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 ...
excel
Excel on Mac
Formulas and Functions
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 

 

  • ruixuan's avatar
    ruixuan
    Copper Contributor
    Sep 24, 2022
    thank you for these posts! I am on the latest version though, so I'll quit it and try again tomorrow or open a new workbook to see if it is fixed.
    • jasmine99's avatar
      jasmine99
      Copper Contributor
      May 15, 2023

      Did it work for you? ruixuan 

      • ruixuan's avatar
        ruixuan
        Copper Contributor
        May 15, 2023

        I couldn't recall clearly, but either restarting the laptop or re-downloading could fix it! jasmine99 

Resources