Announcing LAMBDA: Custom functions without code

%3CLINGO-SUB%20id%3D%22lingo-sub-1956919%22%20slang%3D%22en-US%22%3EAnnouncing%20LAMBDA%3A%20Custom%20functions%20without%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1956919%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Office%20Insiders%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChris%20Gross%2C%20a%20PM%20on%20the%20Excel%20team%2C%20is%20excited%20to%20announce%20a%20new%20function%20in%20Excel%3A%20LAMBDA.%20In%20our%20latest%20blog%20post%2C%20he%20gives%20you%20a%20detailed%20rundown%20of%20this%20new%20function%20and%20shows%20how%20you%20can%20take%20a%20formula%20and%20turn%20it%20into%20your%20own%20named%20custom%20function.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LAMBDA.jpg%22%20style%3D%22width%3A%20800px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F237762iA30E409E7F0DD141%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22LAMBDA.jpg%22%20alt%3D%22LAMBDA.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fblog%2Flambda-excel-custom-functions%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ELearn%20more%20about%20the%20LAMBDA%20function%26gt%3B%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECheers%2C%3C%2FP%3E%0A%3CP%3EEvan%3C%2FP%3E%0A%3CP%3EOffice%20Insider%20Community%20Manager%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EBecome%20an%20Office%20Insider%20and%20gaining%20exclusive%20access%20to%20new%20features%20and%20help%20shape%20the%20future%20of%20Office.%20Join%20Now%3A%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fjoin%2Fwindows%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EWindows%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%7C%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fjoin%2Fmac%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EMac%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%7C%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fjoin%2Fios%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EiOS%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%7C%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fjoin%2Fandroid%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EAndroid%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1956949%22%20slang%3D%22en-US%22%3ERE%3A%20Announcing%20LAMBDA%3A%20Custom%20functions%20without%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1956949%22%20slang%3D%22en-US%22%3Ewhat%20version%20of%20Office%20365%20has%20the%20LAMBDA%20function%3F%20I've%20currently%20updated%20to%2016.0.13530.20000.%20%2C%20but%20I'm%20getting%20a%20%3FNAME%23%20error%20when%20I%20try%20to%20use%20it.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1969228%22%20slang%3D%22en-US%22%3ERE%3A%20Announcing%20LAMBDA%3A%20Custom%20functions%20without%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1969228%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F891412%22%20target%3D%22_blank%22%3E%40DesigningKnights%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20feature%20is%20available%20on%20v%3CSPAN%3Eersion%202012%20Build%2013519.20000%20or%20higher.%20Currently%20the%20feature%20is%20only%20available%20to%20a%20portion%20of%20Insiders%20right%20now%20but%20we%20look%20to%20expand%20the%20availability%20later%20down%20the%20road.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ECheers%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EEvan%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Hello Office Insiders,

 

Chris Gross, a PM on the Excel team, is excited to announce a new function in Excel: LAMBDA. In our latest blog post, he gives you a detailed rundown of this new function and shows how you can take a formula and turn it into your own named custom function. 

 

LAMBDA.jpg

 

Learn more about the LAMBDA function>

 

Cheers,

Evan

Office Insider Community Manager

 

Become an Office Insider and gaining exclusive access to new features and help shape the future of Office. Join Now: Windows | Mac | iOS | Android

3 Replies
what version of Office 365 has the LAMBDA function? I've currently updated to 16.0.13530.20000. , but I'm getting a ?NAME# error when I try to use it.

Hello @DesigningKnights,

 

The feature is available on version 2012 Build 13519.20000 or higher. Currently the feature is only available to a portion of Insiders right now but we look to expand the availability later down the road. 

 

Cheers,

Evan

@Evan_Bolin What's the current status on availability?

If it is still restricted set of Insiders, how do I get into the inner circle?