Excel LAMBDA Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
David
Very powerful, particularly recursion. I would like to see a side-by-side comparison with array formulas (ctrl+shift+enter). I do think you could simplify the function setup by including the function name as a parameter, once the cell is calculated Excel would automatically create the name i.e. no need for the Name Manager steps.
reply
Very powerful, particularly recursion. I would like to see a side-by-side comparison with array formulas (ctrl+shift+enter). I do think you could simplify the function setup by including the function name as a parameter, once the cell is calculated Excel would automatically create the name i.e. no need for the Name Manager steps.
reply
Simon
Great video. So the big question is can you create a vlookup that can take 2 inputs to match rather than just the 1, or bring back a value to the left of the matching value. That would make it good enough to replace VBA. In short can loop down rows yet?
reply
Great video. So the big question is can you create a vlookup that can take 2 inputs to match rather than just the 1, or bring back a value to the left of the matching value. That would make it good enough to replace VBA. In short can loop down rows yet?
reply
Andrea
Hey kevin I hope you can help me with the following issue.. I am trying to do a screen record of an excel formula using windows 10.
the excel function screen tips is not showing up when I record .. do you know how to solve this issue?
reply
Hey kevin I hope you can help me with the following issue.. I am trying to do a screen record of an excel formula using windows 10.
the excel function screen tips is not showing up when I record .. do you know how to solve this issue?
reply
Loida
Hi Kevin, thanks for your amazing tutorial in this very new excel function. Just want to clarify though if my reader can see correctly the result of my formula using the Office insider if the former is not using the Office insider version.
reply
Hi Kevin, thanks for your amazing tutorial in this very new excel function. Just want to clarify though if my reader can see correctly the result of my formula using the Office insider if the former is not using the Office insider version.
reply
ZEE
huummm... !!!don't know... seems will confuse things a bit...
especially when returning to the sheet to make changes or maintenance...
I think I'll stay with good-old-obsolete-10-years-ago VBA for now!!!
reply
huummm... !!!don't know... seems will confuse things a bit...
especially when returning to the sheet to make changes or maintenance...
I think I'll stay with good-old-obsolete-10-years-ago VBA for now!!!
reply
Jack
Hi Kevin, I used to use the OneNote clipping tool but after I updated to MS Office 2019, it just disappeared and can't figure out how to bring it back. Could you help please with a short video
reply
Hi Kevin, I used to use the OneNote clipping tool but after I updated to MS Office 2019, it just disappeared and can't figure out how to bring it back. Could you help please with a short video
reply
Johannes
1st question: what happens when so open the wb in an older Excel App?
2nd: what about speed? Is it the same speed as normal functions or does it slow down as 'indirect' functions do?
reply
1st question: what happens when so open the wb in an older Excel App?
2nd: what about speed? Is it the same speed as normal functions or does it slow down as 'indirect' functions do?
reply
Peter
Thanks for this clear and useful demo of recursive functions.
Hopefully some of my solutions with an explosion of temporary results will now collapse to a single formula, pretty!
reply
Thanks for this clear and useful demo of recursive functions.
Hopefully some of my solutions with an explosion of temporary results will now collapse to a single formula, pretty!
reply
planiolro
Awesome especially the recursion bit was mind blowing for those who do not have programming skills ....I hope you-ll revert to the topic with further examples on recursion .....
reply
Awesome especially the recursion bit was mind blowing for those who do not have programming skills ....I hope you-ll revert to the topic with further examples on recursion .....
reply
Fahim
Hellow - please : when the formula reashing to un ending phase during introductin data? Thank you very much for special vedio- and i am very happy to wrighting for Microsoft -
reply
Hellow - please : when the formula reashing to un ending phase during introductin data? Thank you very much for special vedio- and i am very happy to wrighting for Microsoft -
reply
Add a review, comment
Other channel videos
31:27
