Apr 17 2020 12:24 PM
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 though. The only difference is that I have a mac. Does mac just not have those formulas? How can I get Unique and Sort onto my excel? I have the most up to date version of excel too.
I'd love some help.
Apr 17 2020 12:32 PM
Based on documentation https://support.office.com/en-us/article/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e it shall be available for Mac if you are Office365 subscriber and at least on monthly channel.
Apr 24 2020 09:52 AM
@Sergei Baklan 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?
Apr 24 2020 10:02 AM
@Sergei Baklan I always get this
Apr 24 2020 10:07 AM
Apr 24 2020 10:36 AM
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.
Apr 24 2020 09:37 PM
Solution@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.
Apr 25 2020 04:40 AM - edited Apr 25 2020 04:40 AM
For what it's worth, I just looked at my own update channel (on my MacBook Air) and it's "Production" -- yet I do have UNIQUE, SORT, and the rest of the Array Functions.
Apr 27 2020 08:09 AM
Apr 24 2020 09:37 PM
Solution@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.