Excel LAMBDA Function - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Benson
This is PHENOMENAL! Really loved the tax brackets example. It really solidified the functions for accounting related use cases relevant to my line of work.
Any chance you might now when lambda and let become publicly available ie. for us mere mortals outside of the insider program?
PS: depending on the complexity of an authored lambda function, the approach might result in some painful debugging experiences ;-) . The number of parentheses in the tax bracket example was -beautiful-.
reply
This is PHENOMENAL! Really loved the tax brackets example. It really solidified the functions for accounting related use cases relevant to my line of work.
Any chance you might now when lambda and let become publicly available ie. for us mere mortals outside of the insider program?
PS: depending on the complexity of an authored lambda function, the approach might result in some painful debugging experiences ;-) . The number of parentheses in the tax bracket example was -beautiful-.
reply
gyozakeynesian
Finally! I was never scared of VBA, but if I wanted a more sophisticated programming environment, I'd use another application. What makes Excel useful is the mix of on-the-fly data analysis and clear formatting. This just makes the code clearer and Excel far easier to use. I'm excited to get started with lambda functions. Great video as usual!
reply
Finally! I was never scared of VBA, but if I wanted a more sophisticated programming environment, I'd use another application. What makes Excel useful is the mix of on-the-fly data analysis and clear formatting. This just makes the code clearer and Excel far easier to use. I'm excited to get started with lambda functions. Great video as usual!
reply
Wayne
Hi Mynda. Thanks for this intro to LAMBDA. I find going in and out of Name Manger to be pretty annoying. MS needs an editor like the VBE, except modernized. Maybe a sidebar concept like for settings and accessible via a keyboard like CTRL+1. I assume they are working on a better interface. Thanks for sharing your tips and insights :)) Thumbs up!!
reply
Hi Mynda. Thanks for this intro to LAMBDA. I find going in and out of Name Manger to be pretty annoying. MS needs an editor like the VBE, except modernized. Maybe a sidebar concept like for settings and accessible via a keyboard like CTRL+1. I assume they are working on a better interface. Thanks for sharing your tips and insights :)) Thumbs up!!
reply
Bernard
Thanks Mynda and looking forward to getting this functionality. Quick and somewhat nerdy question-On your tax table calculation, I seem to get a tax of $56166 ($1 and a bit off your calculation) on your $190k income. Probably my mistake but wondering why you add 1 in the col F calculations? Thanks
reply
Thanks Mynda and looking forward to getting this functionality. Quick and somewhat nerdy question-On your tax table calculation, I seem to get a tax of $56166 ($1 and a bit off your calculation) on your $190k income. Probably my mistake but wondering why you add 1 in the col F calculations? Thanks
reply
Geert
I like it so much (like everybody else!) that I-ve started a little library of custom functions of my own.
To bad about some stuff like: no I/O for transferring Defined Names between files, Lambda not very stable, etc.
BTW: thanks for the MEDIAN trick. :-)
reply
I like it so much (like everybody else!) that I-ve started a little library of custom functions of my own.
To bad about some stuff like: no I/O for transferring Defined Names between files, Lambda not very stable, etc.
BTW: thanks for the MEDIAN trick. :-)
reply
Tu
Thank for your great video! I have a query for Lamda function could you give me advice. How can we apply a custom fruction all workbook in excel. That means when we create a function in workbook 1, it will be auto update to other new workbook. Many thanks.
reply
Thank for your great video! I have a query for Lamda function could you give me advice. How can we apply a custom fruction all workbook in excel. That means when we create a function in workbook 1, it will be auto update to other new workbook. Many thanks.
reply
110
Hi! Love your videos! I read that we could use a sheet as a formula. As in the sheet has an input and output, that you then use on another sheet Could you please give us an example on how we could do that.
reply
Hi! Love your videos! I read that we could use a sheet as a formula. As in the sheet has an input and output, that you then use on another sheet Could you please give us an example on how we could do that.
reply
Ian
Hi, Only Wonder : CAN I DO a LAMBDA on this FORMULA: =HYPERLINK(CONCATENATE(-tel:-,F7)) /// Is a call up function to call customer on one click in EXCEL Sheet... /// Thanks /// McRoman ...
reply
Hi, Only Wonder : CAN I DO a LAMBDA on this FORMULA: =HYPERLINK(CONCATENATE(-tel:-,F7)) /// Is a call up function to call customer on one click in EXCEL Sheet... /// Thanks /// McRoman ...
reply
Ivan
Thank you Mynda for sharing your knowledge so generously. It shows to me so well that, sharing is the only function that also multiplies at the same times we all receive it.
reply
Thank you Mynda for sharing your knowledge so generously. It shows to me so well that, sharing is the only function that also multiplies at the same times we all receive it.
reply
CA
I am simply curious to know that is it possible to build functions like SUMIF or VLOOKUP (formula containing range or table array references) using the new LAMBDA function?
reply
I am simply curious to know that is it possible to build functions like SUMIF or VLOOKUP (formula containing range or table array references) using the new LAMBDA function?
reply
Add a review, comment
Other channel videos
