Forum Discussion
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 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.
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.
8 Replies
- SergeiBaklanDiamond Contributor
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.
- tyler4321Copper Contributor
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_EekelenPlatinum Contributor
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.