Forum Discussion
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 ...
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?
- 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.
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
- 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.
