LAMBDA Function in Excel (CUSTOM Excel Formulas 😮)

[@colinhuntley9729]

fantastic, alan! you make things look so easy... i have just updated my excel version to 2024, which has LAMDA, and i shall certainly practicing very soon.

[@stevereed5776]

Thanks Alan, more like this please

[@Computergaga]

Will do. Thank you.

[@JoseAntonioMorato]

Dear Alan, I saw you dragging the formula to other cells, but LAMBDA accepts the range selection and spills the results. 🤗

[@Computergaga]

Awesome! 👍🏼 Thanks, Jose Antonio.

[@westleyempeigne6541]

Great video and it doesn’t look too complicated. My worry is that, I use it in a workbook that is also used by others and they have difficulties understanding what that function is doing!

[@ExcelWithChris]

Love it! Pleased please make a video with a number of samples, from basic to more advanced. Would be great. I have always wanted to use Lambda but have always been wary and scared of using it. The first time I saw one, I think I got such a fright and just switched off. Greetings from South Africa.

[@Computergaga]

Thank you, Chris.

[@kathimills7699]

So nice to see you back at creating awesome content for us! Congrats on your book being added to the MS library!!! I wholeheartedly support that decision

[@Computergaga]

Thank you so much, Kathi. Your comments are appreciated.

[@IvanCortinas_ES]

Excellent explanation, Alan. In fact, it is a very good example, because it also explains how ISOMITTED works, a practically forgotten function. Thanks for sharing.

[@Computergaga]

You're very welcome, Ivan. Thank you.

[@enrikekasijas705]

Very cool stuff ❤ Never used it but I will just for fun 😂 I thought it is much harder to do but you explained so simple that now I get it 😂❤❤❤

[@Computergaga]

'Just for fun' - I love that! Thank you for your comments.

[@gandhisunil3]

Thanks Alan,😊 I am already using Lambda, but is omitted function explanation is amazing🎉 Please make a video of Map and scan if not made already

[@Computergaga]

Thank you very much. Your comments are appreciated. Will do.

[@kebincui]

Brilliant as always! Thanks Alan . I learnt the tips of using optional parameter in lamda and shifting Lamda function to a different workbook. Very useful 👍

[@Computergaga]

Fantastic! Thank you, Kebin. Your comments are much appreciated 🙂

[@totvabe1]

Really useful video!

[@Computergaga]

Thank you very much!

[@sscire]

Hi Alan, I am happy to see this video! I hope more will follow, maybe-as another subscriber suggested-you can follow up by making more videos particularly on "lambda helpers" and especially on AFE which I see you have installed on your Excel. AFE is an excellent tool for writing LAMDA functions and being able to easily transfer them to other worksheets

[@unnikrishnansanthosh]

crystal clear explanation, thank you for sharing Alan

[@Computergaga]

Very welcome. Thank you 🙂

[@patrickschardt7724]

LAMBDAs are so powerful and Microsoft has made many improvements to them already I’m surprised there isn’t a TEXTBETWEEN function given they have added other delimited text functions I have several LAMBDAs including some for common conditional formatting, a more robust formulatext that also shows the reference, and some for data validation

[@Computergaga]

Excellent! Thanks for sharing Patrick 🙂 Good ideas around the Conditional Formatting and enhanced FORMULATEXT 👍🏼

[@luigibru8677]

You are an Excel Magician!

[@Computergaga]

Wow, thank you!

[@excel_along_the_way]

Hi Alan, very cool use of ISOMITTED. In your first iteration of the function you can enter multiple delimiters like {".","/"} without creating an optional argument in the function.

[@Computergaga]

Thanks for the tip, Lester 👍🏼🔥 I guess that remains an option for those that want that approach. Similar to use of arrays in functions such as CHOOSECOLS instead of using the separate arguments.

[@Luciano_mp]

Great tips...Useful. Thank you Alan!

[@Computergaga]

Thank you, Luciano.

[@PaulEBrownbill]

Thanks, great video again. Paul

[@Computergaga]

Glad you enjoyed it. Thank you.

[@teoxengineer]

Thank you Alan, I hope you are going to prepare a video about another Lambda helper Functions (Map, Scan, Reduce, ByRow, ByColumn etc.)

[@Computergaga]

Thank you. I have a video on BYROW and BYCOL already (kzbin.info/www/bejne/aWaumH-If82XbrM), but not on the others, yet 🙂

[@MelissaMay-id6vu]

Very useful 😊 thanks and very well explained

[@Computergaga]

Most welcome 😊 Thank you so much.

[@reng7777]

MAGNIFICENT!!!!

[@Computergaga]

Thank you 😊

[@barttitulaerexcelbart9400]

Very well explained Allan ! I do not use it often but I created (after seeing Mike Girvins video) this formula : =LAMBDA(reference;IFERROR(TOCOL(ADDRESS(ROW(reference);COLUMN(reference);4)&" : "&FORMULATEXT(reference);2);"no formulas in range")) I altered my book.xlst file so I always have it available. But it took me quit some time to actually update the right book.xlst file. Greetings Bart

[@Computergaga]

Thanks, Bart.

[@JCEurovisionFan1996]

What if I don't have the LAMBDA function in Excel?

[@Computergaga]

LAMBDA is only available in Excel 365. It is available in Excel Online if you want to play with it.