Excel LAMBDA Function Tutorial
Vložit
- čas přidán 24. 07. 2024
- In this step-by-step tutorial, learn how you can create your own custom function in Microsoft Excel using Lambda.
👋 Additional resources:
- Access the Excel spreadsheet that I used if you'd like to follow along: 1drv.ms/x/s!AmxrofZZlZ-whKdvV...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⌚ Timestamps
0:00 Introduction
0:55 Become an Office Insider
1:56 Formula vs. function
3:37 Create basic function
8:09 Create more complex function
13:41 Create recursive / looping function
17:59 Wrap up
📃 Watch related playlists and videos
- Playlist with all my Excel videos: • ❎ How to use Excel
🚩 Connect with me on social:
- LinkedIn: / kevinstratvert
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
🔔 Subscribe to my CZcams channel
czcams.com/users/kevlers?...
🎬 Want to watch again? Navigate back to my CZcams channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#lambda #excel - Věda a technologie
🏫 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: czcams.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
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!!! 👌🤩😎
Hi Kevin, this lambda function is great, thanks for sharing some examples of it
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.....
Great video Kevin! Thanks for detailed yet simple explanation and right examples to make us understand LAMBDA! Waiting for its public release! 😊👍
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.
THANKS FOR THIS VIDEO. VERY INFORMATIVE, IT HELPS ME SPECIALLY DOING MY ONLINE SCHOOL ACTIVITIES. AWESOME 👏
This definitely a function I will be using. Thanks for sharing.
Dude, I just got the lambda function! This is an awesome tutorial!!
You're an amazing person Kevin
Yes this is going to be a great help and I love your channel
I had fun watching your video, it has certainly open my eyes up on what can be achieved
Thanks for your tutorial, it help me a great deal. Is there any way to run macro in protected sheet ? Thanks
Bro your content saves my life lots of times. Keep bringing the technology!!!
Thanks! Will do!
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.
Nice video. Keep it up !
EXCELlent tutorial!
Thanks Kevin.
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, woukd the recursion function work if yiu use the some number two times in the name?
Sirach what? A cookie? Kev you’re just the most amazing teacher in the world
I like the way you explained .............. Keep it up !!
Thanks for the heart 😊
This video is highly underrated. I loved how you took it up step by step.
Thanks Kevin 😍🇱🇰
Merry Christmas !!!
💗💖🎄🎁❄☃️✨❤💙💚
From the 🇵🇭
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
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?
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.
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 👍
Can you say about .csv file format in excel and how to extract data from this file format?
Hi Kevin, I know much abt vba and making my own udf. What's faster you think?
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
Kevin, I see that lambda works with an IF statement, but will it work with an IFS statement?
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!
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?
Does anyone know, when the lamda function is fully integrated in excel without to be in the insider program?
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?
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?
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 ٠
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
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 .....
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, we can directly use if function know?
Is Lambda available to all 365 versions? I have Personal. I selected Beta, I cannot locate Lambda.
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!)
Great explanation, kevin, but you didn't explain second part bringing recursion function into lambda in detail
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.
Hello Kevin sir ☺️
I typed =lambda(X,Y,X+Y) and i got #NAME?. Please, what does this mean? Lambda not yet available in my version?
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!
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
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 👍
Hello kevin how to dark mode messenger in pc i hope you see it
I have an annual Office 365 subscription and there was no option to join Office Insider through the Account option
I could not see the Office Insider Option
Your Admin may not like you very much... ;-)
Why cant I get the free Windows Video Editor on my Windows 10?
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.
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
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!
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.
Me as a kid...this is complicated because i still learning in microsoft power point and word :P
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.
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
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.
Lamda lamda lamda!
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 CZcams content that I want to consume. There are only so many hours in the day. I usually go at 2x though 😁
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..👍
I thought it was a video about lambada and that kevin was going to dance the lambada Brazilian way...
When you're already understand how to use the function yet you don't have the Office Insider... lol
Fun fact:the letter from the thumbnail is the greek L/ λ
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 symbol reminds me of Half-Life.
1st view!!!!
1St view!!!
You give 4 secs ago I gave 36 secs ago
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!!!
1st comment, 1st View
Macros are much better