To understand recursion, first you have to understand recursion... although I'm not a rocket surgeon like you, I like solving puzzles simply because they are there and working through your logic has given me hours of fun! About one hour for every minute you spent on the problem! I'd never got into LAMBDA before and it's so easy to use! Thank you for giving me another arrow for my quiver.
Wahoo man! Usted es polvora con Excel. Realmente explotas muy bien la herramienta. Gracias Diarmuid por este nuevo video, lo vi cada minuto de los 47 minutos.
That is a mind-boggling use of lambdas to solve as well s making them more efficient. I'm curious how often you use recusion in your work? And when did the evaluate box start working for let formulas? Is that in the insiders channel still? Regardless, amazing s always Diarmuid.
I'm not sure I've ever used recursion in my work - definitely not a recursive LAMBDA (although I haven't done all that broad a set of work since I learned how, so that's not as strong a statement as it might seem...). And if the formula evaluation box didn't work for LET, I didn't realize! It does struggle with some LAMBDA stuff - if you need something more powerful for that, there's a similar tool in the Advanced Formula Environment plug-in that was made recently and works with (at least some) LAMBDA stuff. Charles Williams also has a LAMBDA explorer that I've heard good things about (but haven't used myself).
Interesting and enjoyable to follow along; although it takes me a while to wrap my head around much. I am curious if there are any Excel Add-Ins you find useful or User-Defined Functions you've developed to be more efficient? Thanks for the videos and good luck in Vegas.
The short answer is no… I spent a pretty large portion of my professional life in an IT environment that was very locked down, so add-ins were totally out of the question. And I still spend a good bit of time in different work settings that I can’t easily port things between - so I’m mostly in the habit of just using Excel ‘out of the box’. I did use some macros regularly, e.g. to set standard print settings, table formats, etc, across my workbooks. And I’m starting to think a bit more about reusable LAMBDAs, but I mostly haven’t made the investment in planning that I’d need to get the most out of that. Thanks for the good wishes - fingers crossed! 🤞🏻
at 13:10, you use Byrow without lambda saying its a "new compact form of byrow" - is it part of insider program or something, since it does not work for me
Yes, exactly that. You can sign up for the insider / beta testing version, and you get to play with the new toys a bit before everyone else! One of the updates that just came out is that you can write a native function as the function argument to BYROW and the various other functions that take functions as arguments - so now you can write =BYROW(array, SUM) instead of =BYROW(array, LAMBDA( rw, SUM( rw ) ) ) It's great!
To understand recursion, first you have to understand recursion... although I'm not a rocket surgeon like you, I like solving puzzles simply because they are there and working through your logic has given me hours of fun! About one hour for every minute you spent on the problem! I'd never got into LAMBDA before and it's so easy to use! Thank you for giving me another arrow for my quiver.
That's great to hear!
That lambda is a mind-boggling masterpiece of recursion.🙌🙌
Wahoo man! Usted es polvora con Excel. Realmente explotas muy bien la herramienta. Gracias Diarmuid por este nuevo video, lo vi cada minuto de los 47 minutos.
Gracias Andrés!
Thanks so much for your experience. Greetings from Peru.
That is a mind-boggling use of lambdas to solve as well s making them more efficient.
I'm curious how often you use recusion in your work?
And when did the evaluate box start working for let formulas? Is that in the insiders channel still?
Regardless, amazing s always Diarmuid.
I'm not sure I've ever used recursion in my work - definitely not a recursive LAMBDA (although I haven't done all that broad a set of work since I learned how, so that's not as strong a statement as it might seem...).
And if the formula evaluation box didn't work for LET, I didn't realize! It does struggle with some LAMBDA stuff - if you need something more powerful for that, there's a similar tool in the Advanced Formula Environment plug-in that was made recently and works with (at least some) LAMBDA stuff. Charles Williams also has a LAMBDA explorer that I've heard good things about (but haven't used myself).
Interesting and enjoyable to follow along; although it takes me a while to wrap my head around much. I am curious if there are any Excel Add-Ins you find useful or User-Defined Functions you've developed to be more efficient? Thanks for the videos and good luck in Vegas.
The short answer is no… I spent a pretty large portion of my professional life in an IT environment that was very locked down, so add-ins were totally out of the question. And I still spend a good bit of time in different work settings that I can’t easily port things between - so I’m mostly in the habit of just using Excel ‘out of the box’. I did use some macros regularly, e.g. to set standard print settings, table formats, etc, across my workbooks. And I’m starting to think a bit more about reusable LAMBDAs, but I mostly haven’t made the investment in planning that I’d need to get the most out of that.
Thanks for the good wishes - fingers crossed! 🤞🏻
at 13:10, you use Byrow without lambda saying its a "new compact form of byrow" - is it part of insider program or something, since it does not work for me
Yes, exactly that. You can sign up for the insider / beta testing version, and you get to play with the new toys a bit before everyone else! One of the updates that just came out is that you can write a native function as the function argument to BYROW and the various other functions that take functions as arguments - so now you can write
=BYROW(array, SUM)
instead of
=BYROW(array, LAMBDA( rw, SUM( rw ) ) )
It's great!