New LAMBDA Function [the Most POWERFUL Function in Excel]

Find out how to use the brand new LAMBDA function in Microsoft Excel to build your own custom functions.

Check out my full courses and ebooks here:

DOWNLOAD any example workbooks here:

SUBSCRIBE & get my 3 FREE eBooks.

CONNECT with me on social:

Thanks for all your support!

[HowToExcelBlog]

Check out my full courses and ebooks here

[Officeinstructor]

Excellent tutorial John!! Awesome introduction to this robust function

[randomCADstuff]

Very quick concise explanation. Thank-you!

[ouwkyuha]

Finally, easy way to calculate on excel

[dolphinloh]

Wow. Thanks for the example workbook. Its a nice formulas to learn. Thanks for the guide too.

[danielk.]

You saved my evening, super cool function. Great news!

[TheMoroaddict]

That escalated quickly ^^
Great guide thank you for sharing useful knowledge!

[ciberiada]

Well done Excel❕ 👏
It becomes *way* easier now to write your own functions. 💻

[mydigitalquill]

Thanks for the quick info!
Explanation on functionality of this feature is not very common here in YT

[chillpill]

Wonderful Video as usual. Very nice.👌👌👌

[wayneedmondson]

Hi John. Thanks for this sneak peak. Looks awesome. I love VBA UDFs. But this goes to the next level. Looking forward to playing with it and learning more about it. Thanks for sharing :) Thumbs up!!

[saturation]

nice video! new lambda function will be a massive help for erveryone. When i saw THAT formula i was like...OK

[JamesRivera]

Nice. But I would hate to try to debug this when you run into a problem.

[OzduSoleilDATA]

Good one! I'm experimenting with these.

[romeo]

Good basic explanation, although it might seem stupid for some, it's pureley for demonstration! Being able to create custom functions, without vba is a good thing. Might help some of us in reducing the number of rows or columns and skipping some intermediate steps we usually take.

[dchager]

You have been really busy John congratulations on your good work.

[LtSerch]

Wow, this is amazing...
Now time to think what can i do with this new function when is released...

[joshuaentwistle]

Using this with LET is going to be super useful too

[rwfrenchGenX]

Thank you for the video and your hard work! You obviously did a lot of research on the more complex queries you made, but this new function reminded me of a Commodore 64 Plus 4 I had in the 80’s. The Plus 4 were 4 function keys you could program to do anything you wanted, they were called hot keys, so in your first few examples it seemed like typical Microsoft where they add additional steps to do what existing formulas could already do. I think the more complex queries you did are where this will be beneficial, especially if they were recorded in a macro in a template, but for the amount of code in your formulas I have to wonder if a lot of this would be better off done in Access, like the append query.

[dputra]

I work in a school and now I need a tool to easily convert lambda workbook to older Excel version. It would make work more sane, but also support people who still uses old Excel version.