Unable to find Lambda and Filter function

%3CLINGO-SUB%20id%3D%22lingo-sub-2153015%22%20slang%3D%22en-US%22%3EUnable%20to%20find%20Lambda%20and%20Filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153015%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20excel%20is%20up%20to%20date%2C%20and%20I%20could%20not%20find%20the%20lambda%20%26amp%3B%20Filter%20function%20in%20the%20beta%20channel.%20Is%20there%20something%20else%20I%20have%20to%20do%20to%20fix%20this%3F%20I'm%20using%20MacBook%20Air.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2153015%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%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2153631%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20find%20Lambda%20and%20Filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153631%22%20slang%3D%22en-US%22%3E%3CP%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%3BYes%2C%20I%20am.%20I%20had%20the%20old%20version%2C%20and%20for%20getting%20these%20functions%2C%20I%20have%20updated%20it%20to%20the%20latest%20365%20(16.47).%20Please%20have%20a%20look%20at%20the%20screenshot%20attached%20for%20your%20reference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2153702%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20find%20Lambda%20and%20Filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153702%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F973583%22%20target%3D%22_blank%22%3E%40Shamalshaz%3C%2FA%3E%26nbsp%3BI'm%20far%20from%20an%20expert%20on%20this%20subject%2C%20but%20does%20it%20say%20you%20have%20an%20MS365%20subscription%20under%26nbsp%3BExcel%2C%20About%20Microsoft%20Excel%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%22Screenshot%202021-02-21%20at%2019.03.36.png%22%20style%3D%22width%3A%20227px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256405iB92D605212D4A779%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-02-21%20at%2019.03.36.png%22%20alt%3D%22Screenshot%202021-02-21%20at%2019.03.36.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2153759%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20find%20Lambda%20and%20Filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153759%22%20slang%3D%22en-US%22%3E%3CP%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%3EPlease%20have%20a%20look%20at%20the%20attached%20screenshot%3B%20I%20believe%20this%20will%20ensure%20the%20365%20subscriptions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2153770%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20find%20Lambda%20and%20Filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153770%22%20slang%3D%22en-US%22%3EIt%20seems%20you%20have%20a%20stand-alone%20license%20for%20Excel%202019.%20That's%20not%20the%20same%20as%20a%20MS365%20subscription.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2153797%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20find%20Lambda%20and%20Filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153797%22%20slang%3D%22en-US%22%3E%3CP%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%3EPlease%20could%20you%20have%20a%20look%20at%20the%20screenshot%20attached%3B%20this%20says%20365%20subscriptions.%20If%20not%2C%20please%20correct%20me%20and%20what%20I%20can%20do%20to%20get%20the%20correct%20version%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2154754%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20find%20Lambda%20and%20Filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2154754%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F973583%22%20target%3D%22_blank%22%3E%40Shamalshaz%3C%2FA%3E%26nbsp%3BYou%20indeed%20seem%20to%20be%20paying%20for%20a%20monthly%20subscription%2C%20but%20did%20you%20also%20install%20the%20Office%20apps%20that%20came%20with%20it%3F%20You%20earlier%20version%20suggests%20that%20you%20are%20using%20a%20stand-alone%20version%20of%20Excel%20for%20Mac.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

My excel is up to date, and I could not find the lambda & Filter function in the beta channel. Is there something else I have to do to fix this? I'm using MacBook Air.

19 Replies

@Shamalshaz Are you an MS365 subscriber?

@Riny_van_Eekelen Yes, I am. I had the old version, and for getting these functions, I have updated it to the latest 365 (16.47). Please have a look at the screenshot attached for your reference.

 

@Shamalshaz I'm far from an expert on this subject, but does it say you have an MS365 subscription under Excel, About Microsoft Excel

 

Screenshot 2021-02-21 at 19.03.36.png

@Riny_van_EekelenPlease have a look at the attached screenshot; I believe this will ensure the 365 subscriptions.

It seems you have a stand-alone license for Excel 2019. That's not the same as a MS365 subscription.

@Riny_van_EekelenPlease could you have a look at the screenshot attached; this says 365 subscriptions. If not, please correct me and what I can do to get the correct version?

@Shamalshaz You indeed seem to be paying for a monthly subscription, but did you also install the Office apps that came with it? You earlier version suggests that you are using a stand-alone version of Excel for Mac.

@Riny_van_EekelenI've downloaded these office files after the new subscription to get the new futures that are not available in the previous version.

@Shamalshaz Downloaded yes, but did you install them also? When I migrated from a stand-alone Excel for Mac version, the new Excel was installed on my Mac. Then I needed to sign in with my MS account and I was ready to go. 

@Riny_van_Eekelen Yes I have installed the package that is the only reason I have the outlook available at present as my previous student version doesn't include the Outlook.

@Shamalshaz Sorry, can't help you any further. Perhaps some else who knows exactly how all these different versions interact with each other (or not).

As said, I had an old Excel version running on my Mac (and all the other Office programs). Just installed what was then called Office 365 beside it. All the new software was included from the start.

@Riny_van_EekelenIs it possible if I'm sharing any desk if you could cross-check something that might help?

I really need this to be fixed for my next steps in excel, please.

@Shamalshaz It's not that I don't want to. I just wouldn't know what to do to help you.

@Riny_van_EekelenThank you for your time and effort to support me on this matter.

Please let me know if you know somebody who is an expert in this that I write to them.

Once again, thanks and I appreciated your support.

@Riny_van_Eekelen Please note that in other way i have Microsoft windows installed on my mac and i have installed the office 365 in the windows now.

 

I could see the filter function is appearing but Lamba is still not available.

 

Could you please share your thought?

@Shamalshaz 

Are you on Beta channel?

Yes I'm

@Sergei Baklan Yes I'm, Could you please help me out.

@Shamalshaz , sorry, I'm not working on Microsoft and can't help with concrete case. I'd recommend to Send a Frown as instructed at the end of this Try LAMBDA: Custom functions without code (office.com) post.