Is FILTER and LET Function available for Microsoft 365 subscribers in MAC ?

%3CLINGO-SUB%20id%3D%22lingo-sub-1713037%22%20slang%3D%22en-US%22%3EIs%20FILTER%20and%20LET%20Function%20available%20for%20Microsoft%20365%20subscribers%20in%20MAC%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1713037%22%20slang%3D%22en-US%22%3E%3CP%3EI%20designed%20a%20dashboard%20for%20someone%20using%20a%20LET%20and%20FILTER%20in%20a%20number%20of%20places.%3CBR%20%2F%3EMine%20is%20the%20same%20subscription%20but%20I%20work%20on%20windows.%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20I%20handed%20over%20the%20file%20to%20my%20MAC%20client%2C%20he%20didn't%20have%20filter%20and%20let%20function%2C%3CBR%20%2F%3EWe%20have%20the%20exact%20same%20subscription.%3CBR%20%2F%3E%3CBR%20%2F%3EHe%20just%20installed%20the%20new%20office%2C%20so%20update%20shouldn't%20be%20an%20issue.%3CBR%20%2F%3EWhat%20should%20I%20be%20do%3F%3CBR%20%2F%3EWait%20for%20some%20update%2C%20or%20rewrite%20all%20my%20formulas%3F%3CBR%20%2F%3E%3CBR%20%2F%3ELET%20can%20still%20be%20replaces%20easily%2C%20FILTER%20is%20a%20must%20have.%3CBR%20%2F%3EI'm%20Stuck.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1713037%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1713244%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20FILTER%20and%20LET%20Function%20available%20for%20Microsoft%20365%20subscribers%20in%20MAC%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1713244%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F523656%22%20target%3D%22_blank%22%3E%40Nishkarsh31%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20why%20your%20Mac%20client%20isn't%20seeing%20them.%20They're%20both%20available%20to%20me%20on%20this%20subscription%20to%20Microsoft%20Office%20365%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1601042977148.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222092iD0DBC6CD386D0E0C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22mathetes_0-1601042977148.png%22%20alt%3D%22mathetes_0-1601042977148.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I designed a dashboard for someone using a LET and FILTER in a number of places.
Mine is the same subscription but I work on windows.

When I handed over the file to my MAC client, he didn't have filter and let function,
We have the exact same subscription.

He just installed the new office, so update shouldn't be an issue.
What should I be do?
Wait for some update, or rewrite all my formulas?

LET can still be replaces easily, FILTER is a must have.
I'm Stuck.

2 Replies
Highlighted

@Nishkarsh31 

 

Not sure why your Mac client isn't seeing them. They're both available to me on this subscription to Microsoft Office 365

mathetes_0-1601042977148.png

 

Highlighted

Thanks. As soon as I get that mac in my hand.
I should be able to get the cause@mathetes