SOLVED

Unique and Sort formulas not showing up on Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1316727%22%20slang%3D%22en-US%22%3EUnique%20and%20Sort%20formulas%20not%20showing%20up%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1316727%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20excel%20has%20the%20formulas%20Unique%20and%20Sort%20because%20there%20are%20how-to%20articles%20for%20them%20online%20but%20I've%20also%20seen%20them%20working%20on%20a%20windows%20computer.%20For%20some%20reason%2C%20they%20never%20show%20up%20for%20me%20though.%20The%20only%20difference%20is%20that%20I%20have%20a%20mac.%20Does%20mac%20just%20not%20have%20those%20formulas%3F%20How%20can%20I%20get%20Unique%20and%20Sort%20onto%20my%20excel%3F%20I%20have%20the%20most%20up%20to%20date%20version%20of%20excel%20too.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20love%20some%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1316727%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1316763%22%20slang%3D%22en-US%22%3ERe%3A%20Unique%20and%20Sort%20formulas%20not%20showing%20up%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1316763%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F626747%22%20target%3D%22_blank%22%3E%40tyler4321%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBased%20on%20documentation%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Funique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Funique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e%3C%2FA%3E%26nbsp%3Bit%20shall%20be%20available%20for%20Mac%20if%20you%20are%20Office365%20subscriber%20and%20at%20least%20on%20monthly%20channel.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1336140%22%20slang%3D%22en-US%22%3ERe%3A%20Unique%20and%20Sort%20formulas%20not%20showing%20up%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1336140%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThat%20what%20I%20thought%20too%20but%20it%20never%20works%20for%20me.%20I%20have%20office%20360%20too.%20Is%20there%20something%20I%20can%20do%20to%20check%3F%20Or%20do%20I%20need%20to%20turn%20something%20on%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202020-04-24%20at%2010.51.19%20AM.png%22%20style%3D%22width%3A%20470px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186517i3D17B8CAB9015A6A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screen%20Shot%202020-04-24%20at%2010.51.19%20AM.png%22%20alt%3D%22Screen%20Shot%202020-04-24%20at%2010.51.19%20AM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1336163%22%20slang%3D%22en-US%22%3ERe%3A%20Unique%20and%20Sort%20formulas%20not%20showing%20up%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1336163%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20always%20get%20this%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202020-04-24%20at%2011.01.36%20AM.png%22%20style%3D%22width%3A%20393px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186520i315FC96677853029%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screen%20Shot%202020-04-24%20at%2011.01.36%20AM.png%22%20alt%3D%22Screen%20Shot%202020-04-24%20at%2011.01.36%20AM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1336171%22%20slang%3D%22en-US%22%3ERe%3A%20Unique%20and%20Sort%20formulas%20not%20showing%20up%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1336171%22%20slang%3D%22en-US%22%3EExcel%20doesn't%20even%20recognize%20that%20Unique%20or%20Sort%20is%20a%20formula%20for%20me.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1336238%22%20slang%3D%22en-US%22%3ERe%3A%20Unique%20and%20Sort%20formulas%20not%20showing%20up%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1336238%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F626747%22%20target%3D%22_blank%22%3E%40tyler4321%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOnly%20Office365%20subscription%20is%20not%20enough%2C%20you%20are%20to%20be%20on%20right%20channel.%20If%20that's%20semi-annual%20or%20like%20such%20functions%20are%20not%20available%20on%20it%20so%20far.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20not%20sure%20how%20to%20check%20that%20on%20Mac.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337088%22%20slang%3D%22en-US%22%3ERe%3A%20Unique%20and%20Sort%20formulas%20not%20showing%20up%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337088%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F626747%22%20target%3D%22_blank%22%3E%40tyler4321%3C%2FA%3E%26nbsp%3BIn%20Excel%20on%20the%20Mac%2C%20press%20Help%20in%20the%20top%20menu%20and%20%22Check%20for%20Updates%22.%20In%20the%20next%20dialogue%2C%20press%20Advanced...%3C%2FP%3E%3CP%3EHere%20you%20can%20check%20and%20change%20your%20Update%20channel.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-04-25%20at%2006.35.25.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186587i5B43556DF1AEB324%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-04-25%20at%2006.35.25.png%22%20alt%3D%22Screenshot%202020-04-25%20at%2006.35.25.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337439%22%20slang%3D%22en-US%22%3ERe%3A%20Unique%20and%20Sort%20formulas%20not%20showing%20up%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337439%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F626747%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3E%40tyler4321%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20what%20it's%20worth%2C%20I%20just%20looked%20at%20my%20own%20update%20channel%20(on%20my%20MacBook%20Air)%20and%20it's%20%22Production%22%20--%20yet%20I%20do%20have%20UNIQUE%2C%20SORT%2C%20and%20the%20rest%20of%20the%20Array%20Functions.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1587814736622.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186628iFB4CE435E12DE911%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22mathetes_0-1587814736622.png%22%20alt%3D%22mathetes_0-1587814736622.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1340746%22%20slang%3D%22en-US%22%3ERe%3A%20Unique%20and%20Sort%20formulas%20not%20showing%20up%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1340746%22%20slang%3D%22en-US%22%3EThis%20worked!%20I%20was%20on%20production%20and%20I%20switched%20to%20insider%20fast%20and%20now%20I%20have%20them!%20Thank%20you!%20I%20don't%20know%20why%20that%20worked%20for%20me%20but%20it%20did.%20Thank%20you%20so%20much.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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. 

8 Replies
Highlighted

@tyler4321 

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. 

Highlighted

@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? 

 

Screen Shot 2020-04-24 at 10.51.19 AM.png

Highlighted

@Sergei Baklan I always get this Screen Shot 2020-04-24 at 11.01.36 AM.png

Highlighted
Excel doesn't even recognize that Unique or Sort is a formula for me.
Highlighted

@tyler4321 

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.

Highlighted
Best Response confirmed by tyler4321 (Occasional Contributor)
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.

Screenshot 2020-04-25 at 06.35.25.png

 

Highlighted

@tyler4321@Riny_van_Eekelen 

 

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.

mathetes_0-1587814736622.png

 

Highlighted
This worked! I was on production and I switched to insider fast and now I have them! Thank you! I don't know why that worked for me but it did. Thank you so much.