Hi Deb, This is the 1st video that I watched on Your Channel - I liked it. ✓ The names were very funny - Tom Bruise . . Bradley Hooper . . Jon Scam 😁 ✓ Request: please provide a downloadable practice Workbook. It will be very, very helpful 🙏🏿 Thank You!
It is very easy to create new functions to use in the cells using VBA Functions (not subs). Lambda let us do SIMPLE functions, without VBA. Nice. But VBA allows more complex functions since it's a full program, and Lambda is just one formula.
Yes, but for the average user sitting at their desk, VBA is extremely difficult to learn and most have no need to learn it. LAMBDAS are a simpler and easier for most to understand. This is a basic LAMBDA, they can be very complex.
@@cellmatestraining you are right, but even low complexity Lambdas are also not for the average user sitting at their desk.. let alone very complex ones. Average users will NEVER create a personal function.
@@cellmatestraining depends of the problem... actually VBA in many cases is less complicated than a complex lambda with all those nested functions... mpa, let, lampda inside other 3, lol... when lambdas get mediu complex, it's already impossible to read compared to an easy procedural sequence of lines... not to mention how easier it is to loop, and other things... recursiveslambda is yeat harder to understand when you are not above avrg user. But yeah, I know where you aim it and it's quite right. Actually both tools serves same purpose, but for most time, different problems... VBA is where it would be way too complex to do in lambas, or actually impossible.
@@smanzoli every formula I show someone jumps into the comments to say why something else is better. 😂 That’s fine! I’m simply here showing how these functions work. I’m not telling you to use them if you find something else better or easier.
Thank you Deb, very clearly explained. I'd like to see more videos on Lambda as I see this as a very useful tool. Maybe in conjunction with Reduce/Scan functions!!!
@@Ezra-b1w thank you so much! Yes! I understand what it feels like to not understand Excel so I try and explain as clearly as possible! Thank you for your nice comment :)
@@cellmatestraining thank you for the feedback. any thoughts about a way to calculate empty cellls using subtotals? I managed to do that with helper columns but haven't figured away to do it :) thank you in advance
Hi Rosy, great question! There is no button as such to make them accessible across workbooks. The simplest way I have found is to simply click on the cell that contains the LAMBDA, copy and paste into a new workbook. That copies the formula across. You can delete the formula once you’ve done that. The named range/formula should now stay in the new workbook.
Hi Deb,
This is the 1st video that I watched on Your Channel - I liked it.
✓ The names were very funny - Tom Bruise . . Bradley Hooper . . Jon Scam 😁
✓ Request: please provide a downloadable practice Workbook. It will be very, very helpful 🙏🏿
Thank You!
Very clear explanation Deb with interesting examples. Thanks for posting on UA-cam.
It is very easy to create new functions to use in the cells using VBA Functions (not subs).
Lambda let us do SIMPLE functions, without VBA. Nice. But VBA allows more complex functions since it's a full program, and Lambda is just one formula.
Yes, but for the average user sitting at their desk, VBA is extremely difficult to learn and most have no need to learn it.
LAMBDAS are a simpler and easier for most to understand. This is a basic LAMBDA, they can be very complex.
@@cellmatestraining you are right, but even low complexity Lambdas are also not for the average user sitting at their desk.. let alone very complex ones. Average users will NEVER create a personal function.
@@cellmatestraining depends of the problem... actually VBA in many cases is less complicated than a complex lambda with all those nested functions... mpa, let, lampda inside other 3, lol... when lambdas get mediu complex, it's already impossible to read compared to an easy procedural sequence of lines... not to mention how easier it is to loop, and other things... recursiveslambda is yeat harder to understand when you are not above avrg user. But yeah, I know where you aim it and it's quite right. Actually both tools serves same purpose, but for most time, different problems... VBA is where it would be way too complex to do in lambas, or actually impossible.
@@smanzoli every formula I show someone jumps into the comments to say why something else is better. 😂 That’s fine! I’m simply here showing how these functions work. I’m not telling you to use them if you find something else better or easier.
Thank you Deb, very clearly explained. I'd like to see more videos on Lambda as I see this as a very useful tool. Maybe in conjunction with Reduce/Scan functions!!!
Thanks, Steve!
Thank you very much, you are really an expert in simplifying complex things.
You do it in a fun and friendly way
@@Ezra-b1w thank you so much! Yes! I understand what it feels like to not understand Excel so I try and explain as clearly as possible! Thank you for your nice comment :)
Thank you Debs. This is informative.
How about we get Python in Excel video? 😊
Possibly soon Deborah ;-)
Great video - so clear.
Thank you for this
Teaching it this way makes it super easy
How is the performance if i would use it on ranges exceeding 3000 rows?
You're welcome! You shouldn't have any problems using it on larger datasets. It's the same as using any other function. Thank you for watching!
@@cellmatestraining thank you for the feedback.
any thoughts about a way to calculate empty cellls using subtotals? I managed to do that with helper columns but haven't figured away to do it :)
thank you in advance
@@ahmed007Jabertry using AGGREGATE instead. It will sun cells and you can choose to ignore blanks.
The way you present is very clear and helpful. Thankyou!
@@peterleigh5809 you’re welcome! Thank you for watching!
Would you (please) do a video on the best and easiest way to share these Lambdas in different workbooks
Hi Rosy, great question! There is no button as such to make them accessible across workbooks. The simplest way I have found is to simply click on the cell that contains the LAMBDA, copy and paste into a new workbook. That copies the formula across. You can delete the formula once you’ve done that. The named range/formula should now stay in the new workbook.
Best, concise explanation of LAMBDA that I've come across so far!
Thank you!
Thanks for this very informative video. by the way the title is well chosen.
❤❤❤❤❤❤
Thank you so much.
What about Lambda Helper functions?
Best video about LAMBDA so far. Now I know what this function does and how helpful it can be. 👏🏽👏🏽👏🏽👏🏽👏🏽
Amazing! Glad you enjoyed the video!
U r an Amazing Teacher. Lambda function explained in plain vanilla . A 5 star rating for u. Thanks
Thank you so much!
Awesome explanation! 💚🐏🙂
Nicely done Deb!
This presentation was very informative
Thank you!
No one is going to comment on silence of the LAMBDAS ?! :)
I know right? I was so proud of that. 😂
@@cellmatestraining any new uploads about the new In-excel-python feature?