🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Very helpful. As an estimator in the field of construction, this video lesson will allow me cross over into other related disciplines with one formula using lambda.
i was doing fine w/ my old microsoft word 2016. moving into newer laptops w/ office365 complicates my simple calculations but then again this channel taught me how to.....Thanks Kev.....
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.
Wow, this is great! I'll try it, and if everything works out ok I can definitely see myself using it a lot. Thanks once more Kevin, you totally rule!!! 👌🤩😎
Show me 2 different recursive Lambda() functions that play upon each other and I'll be even more impressed ^_^ (I am going to have experimenting with this; it's now on enterprise channel!)
This was a great tutorial. Easy to follow and understand. I do have one question though, how do I make the function work across multiple worksheets in a workbook? When I created the function on my worksheet labeled "2020", it worked great. When used on my worksheet "2021", it wouldn't work. The actual formula, =LAMBDA(DateIn,'2020'!I396-'2020'!H396+1) kept referring back to "2020." When I changed the formula to say "2021" it messed up my information on "2020." Any assistance is much appreciated.
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 .....
Great explanation. However, changing values manually (i.e. the discount percentage) instead of using a parameter is bad practice ☹ I'd use parameters both for the threshold quantities for discount and the discount percentages.
You can do everything you can currently do in Microsoft Access, and then much more, with Microsoft Power Platform. Don't waste your time with Microsoft Access.
Nice intro - thanks! But your use cases are IMHO opinion not the best. In the discount example you could replace the nested "if" with a simple (X) lookup table.. The "remove the digits" example makes sense because after all these years Excel still does not have regular expressions - the IMHO best solutions to clean up or validate input.
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!
What you now call Lambda(), a zillion years ago we called it a macro. As I remember, macros were rather hacker attractions. I'm now 80 yrs old... am I missing something.
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.
Quick note: All Beta Users Are Created Equal, But Some Are More Equal Than Others. • Insider: check • Beta: check LAMBDA function: ERROR, function not found. :-( Use it a lot, I will. For all the obvious reasons. This is major ultra. Combine it with the LET function inside, and the only things it won't be able to do are: make coffee and order pizza. ;-)
That works :) That's how I get through all the TH-cam content that I want to consume. There are only so many hours in the day. I usually go at 2x though 😁
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?
For bring back value to the left, check out the new xlookup function. It solves for a lot of the vlookup deficiencies. For two value look up, I also just created an additional concatenate column and then searched on the merged value. It's a cheap and easy way to run a look up on two inputs 😁
@@KevinStratvert Thanks for th reply - I did not know about the XLOOKUP function so that is awesome. I did create my own lookup to bring back value to the left and I also called it XLOOKUP! Ironic or what. The trick of concatenating works well and I have used that trick more than once. Great videos and again - thank you for taking the time to 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
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 ٠
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?
Hi Kevin - I'm using office 365 provided my organization I don't see office insider option. How do I active office insider in this case if I want to activate it?
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?
I reversed the order of the nested IF (as in, discount is 0 being the first logical test and quantity >150 as third nested IF) but it didn't work . Can you please give me a hint as to why?
Hi Kevin ,I follow Lambda Function Goto Account Setting And Changed The Channel Name Now My Channel is Beta Channel,But the Lambda function is not displayed in my office 365. Any Change my Office please make a video about lambda Inserting function
Hi Kevin. I am having trouble with a word document when attaching it in an email. The problem is that I have previously sent a word document through an email and I had to make some changes on the same word document - the changes were made and save it on my laptop. when I try to sent this update document to the same person, somehow is pulling the older version and attaching it to the email. Where or how this is possible? or where this version is save? do you know why this is happening? thanks in advance
Probably the easiest way to solve for this is to open the correct document on your computer. You can then save to the cloud via OneDrive or Google Drive. This way you won't have to attach to email and you won't end up with multiple versions/revisions. This way you'll always work off the most current version... and so will others who are working with you. Hope that helps!
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!!!
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Very helpful. As an estimator in the field of construction, this video lesson will allow me cross over into other related disciplines with one formula using lambda.
i was doing fine w/ my old microsoft word 2016. moving into newer laptops w/ office365 complicates my simple calculations but then again this channel taught me how to.....Thanks Kev.....
Dude, I just got the lambda function! This is an awesome tutorial!!
Sirach what? A cookie? Kev you’re just the most amazing teacher in the world
THANKS FOR THIS VIDEO. VERY INFORMATIVE, IT HELPS ME SPECIALLY DOING MY ONLINE SCHOOL ACTIVITIES. AWESOME 👏
Bro your content saves my life lots of times. Keep bringing the technology!!!
Thanks! Will do!
This video is highly underrated. I loved how you took it up step by step.
I had fun watching your video, it has certainly open my eyes up on what can be achieved
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.
Great video Kevin! Thanks for detailed yet simple explanation and right examples to make us understand LAMBDA! Waiting for its public release! 😊👍
Hi Kevin, this lambda function is great, thanks for sharing some examples of it
Wow, this is great! I'll try it, and if everything works out ok I can definitely see myself using it a lot.
Thanks once more Kevin, you totally rule!!! 👌🤩😎
I like the way you explained .............. Keep it up !!
Thanks for the heart 😊
This definitely a function I will be using. Thanks for sharing.
Show me 2 different recursive Lambda() functions that play upon each other and I'll be even more impressed ^_^ (I am going to have experimenting with this; it's now on enterprise channel!)
I'm your new subscriber here.. Thank you for making this wonderful video. it helps a lot.
Thanks for the note Jessrick! Thanks for subscribing 👍
Wow Kevin that kind of hard when you got to the number removal. Sort of understood the SUBSTITUTE and LEFT, but what does the RIGHT and LEN do
You're an amazing person Kevin
Merry Christmas !!!
💗💖🎄🎁❄☃️✨❤💙💚
From the 🇵🇭
Yes this is going to be a great help and I love your channel
This was a great tutorial. Easy to follow and understand. I do have one question though, how do I make the function work across multiple worksheets in a workbook? When I created the function on my worksheet labeled "2020", it worked great. When used on my worksheet "2021", it wouldn't work. The actual formula, =LAMBDA(DateIn,'2020'!I396-'2020'!H396+1) kept referring back to "2020." When I changed the formula to say "2021" it messed up my information on "2020." Any assistance is much appreciated.
Nice video. Keep it up !
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 .....
Thanks Kevin.
EXCELlent tutorial!
Great explanation.
However, changing values manually (i.e. the discount percentage) instead of using a parameter is bad practice ☹
I'd use parameters both for the threshold quantities for discount and the discount percentages.
Kevin bro!! Can you please make a video on how to use Microsoft acess,, plzzz
You can do everything you can currently do in Microsoft Access, and then much more, with Microsoft Power Platform. Don't waste your time with Microsoft Access.
Video on Microsoft Access is landing in an hour and a half 👍
I'm sorry Kevin, is too complicated for me,, this video I can't get understand about Xls format .. anyhow,, u are doing great about the video..👍
Thanks Kevin 😍🇱🇰
Nice intro - thanks!
But your use cases are IMHO opinion not the best.
In the discount example you could replace the nested "if" with a simple (X) lookup table..
The "remove the digits" example makes sense because after all these years Excel still does not have regular expressions - the IMHO best solutions to clean up or validate input.
Great explanation, kevin, but you didn't explain second part bringing recursion function into lambda in detail
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!
What you now call Lambda(), a zillion years ago we called it a macro. As I remember, macros were rather hacker attractions. I'm now 80 yrs old... am I missing something.
Fun fact:the letter from the thumbnail is the greek L/ λ
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.
Thanks for your tutorial, it help me a great deal. Is there any way to run macro in protected sheet ? Thanks
Quick note: All Beta Users Are Created Equal, But Some Are More Equal Than Others.
• Insider: check
• Beta: check
LAMBDA function: ERROR, function not found. :-(
Use it a lot, I will. For all the obvious reasons. This is major ultra.
Combine it with the LET function inside, and the only things it won't be able to do are: make coffee and order pizza. ;-)
You can speed up the playback to 1.5 and you could still understand it.
That works :) That's how I get through all the TH-cam content that I want to consume. There are only so many hours in the day. I usually go at 2x though 😁
Hi Kevin, Thank you for that great video.
Unfortunately I'm on Excel 365 but Excel seems not to recognize/accept LAMBDA !?
Thx for your answer !
You’ll need to enroll in the Office Insider program and opt into the beta channel. The very beginning of the video shows how. Hope that helps!
Hello Kevin sir ☺️
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?
For bring back value to the left, check out the new xlookup function. It solves for a lot of the vlookup deficiencies. For two value look up, I also just created an additional concatenate column and then searched on the merged value. It's a cheap and easy way to run a look up on two inputs 😁
@@KevinStratvert Thanks for th reply - I did not know about the XLOOKUP function so that is awesome. I did create my own lookup to bring back value to the left and I also called it XLOOKUP! Ironic or what. The trick of concatenating works well and I have used that trick more than once. Great videos and again - thank you for taking the time to reply.
How to get Microsoft store on your Android Phone or Iphone Phone
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
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 ٠
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?
Hi Kevin, I know much abt vba and making my own udf. What's faster you think?
Hi, we can directly use if function know?
Hi Kevin - I'm using office 365 provided my organization I don't see office insider option. How do I active office insider in this case if I want to activate it?
I thought it was a video about lambada and that kevin was going to dance the lambada Brazilian way...
Kevin, I see that lambda works with an IF statement, but will it work with an IFS statement?
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?
I have an annual Office 365 subscription and there was no option to join Office Insider through the Account option
Me as a kid...this is complicated because i still learning in microsoft power point and word :P
I reversed the order of the nested IF (as in, discount is 0 being the first logical test and quantity >150 as third nested IF) but it didn't work . Can you please give me a hint as to why?
Is Lambda available to all 365 versions? I have Personal. I selected Beta, I cannot locate Lambda.
I typed =lambda(X,Y,X+Y) and i got #NAME?. Please, what does this mean? Lambda not yet available in my version?
thanks, woukd the recursion function work if yiu use the some number two times in the name?
That symbol reminds me of Half-Life.
Can you say about .csv file format in excel and how to extract data from this file format?
Does anyone know, when the lamda function is fully integrated in excel without to be in the insider program?
Hi Kevin ,I follow Lambda Function Goto Account Setting And Changed The Channel Name Now My Channel is Beta Channel,But the Lambda function is not displayed in my office 365. Any Change my Office please make a video about lambda Inserting function
Hi Kevin. I am having trouble with a word document when attaching it in an email. The problem is that I have previously sent a word document through an email and I had to make some changes on the same word document - the changes were made and save it on my laptop. when I try to sent this update document to the same person, somehow is pulling the older version and attaching it to the email. Where or how this is possible? or where this version is save? do you know why this is happening? thanks in advance
Probably the easiest way to solve for this is to open the correct document on your computer. You can then save to the cloud via OneDrive or Google Drive. This way you won't have to attach to email and you won't end up with multiple versions/revisions. This way you'll always work off the most current version... and so will others who are working with you. Hope that helps!
When you're already understand how to use the function yet you don't have the Office Insider... lol
Can u please show me how to use Adobe premier pro editing software
I've got it on my list. Most recently, I've been using DaVinci Resolve 17 as my main editing app so that's been my focus.
Why cant I get the free Windows Video Editor on my Windows 10?
I could not see the Office Insider Option
Your Admin may not like you very much... ;-)
Anyone know how to replace the cell reference B7 in the formula with the variable "Boxes" with just a mouse click as he did at 10:30?
I signed up for insider but lambda is not working
The only other thing to check... make sure to also join the beta channel.
@@KevinStratvert I have and it's still not showing up when I input =lambda, to clarify I have Microsoft 365 family membership
I would like to make my recordings more clear I mean very clear but I am no been able to please help me kevin
Can you tell me more? Video or audio recordings?
@@KevinStratvertMy texts inside the recording is not clear. I mean the texts in my video recording
Hello kevin how to dark mode messenger in pc i hope you see it
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!!!
Name manager already in excel so why we use lambda .
You can’t create functions within the name manager today e.g you can’t use it to pass in a value and get a result unless you use lambda.
Lamda lamda lamda!
1st comment, 1st View
1st view!!!!
1St view!!!
You give 4 secs ago I gave 36 secs ago
Macros are much better