Dear Chandoo, Sir, I really liked the way you introduced Lambda in a very simple way and very effective for business situations. Tough made easy. Super Lambda Techniques of your teaching, Sir. Thanks 😊
I was having trouble copying my defined Lambda into the naming Lambda box. The Ctrl + C and Ctrl + V didn't work. So I would have to type it out again. What is going wrong? @@chandoo_
Absolutely unreal. Programming and naming our own functions in Excel. It's happening!!! Thank you for providing these explanations for these new features. I'm literally going to start using this as soon as I get back to work on Monday. On another note, as someone who's spent the majority of their life in education, I just wanted to take a moment to praise your ability to break these concepts down in an incredibly concise and easy to understand manner. We need a million professors of your caliber in the states ASAP, please.
I will use this to create severity metrics (dollars/counts). An additional video would be nice to show how to create these functions so they are in every workbook. So they could be added to the workbook when it's created. Thanks!
Sounds like an awesome usecase. There are limited options to share LAMBDAs now. I talk about the "sharing" aspect and compare it with "UDFs" here - chandoo.org/wp/what-is-lambda-function/
Thanks for this explanation and demos. You get me reconsidering my feelings about LAMBDA. I'd been reluctant because they've been compared to UDFs and I've never needed a UDF. After your video, I'm willing to open my mind and look for possibilities.
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.
Thanks Sir 🙏💕 Mostly used formula n concept in Industry of database n finance, requesting kindly make videos on it. Because Managers are Asking mostly queries at interview Time.
Just like to know that lambda function uses only two variable or we can use it for more than two variables. Isn't formatting can be used in lambda i.e. converting to date format... Excellent video.......
You can use any number of variables (including zero). I show all of that in the video. Unfortunately, we can't yet control the output format with formulas. It might happen in future.
This is great / easy to understand. Unfortunately it is only available in GM On-Line for our company (which for PC does not have the name manager). Great video though and I have been playing around with it.
Thanks Chandoo, can't lamda function saved and work on every other workbook open? I mean once the function is been created, if it could be subsiquently use in other workbooks?
Right now, LAMBDAs are limited to the workbook in which you write them. By using the free "Advanced Formula Environment" addin by Microsoft, we can export / import lamdbas. I will be adding a video on AFE soon. But do watch this one by Mr Excel - ua-cam.com/video/ySaDkjx3TlI/v-deo.html
You can use XY plots to make anything. Plus Excel also have 3D options on many of the graphs. I suggest seeing this for some ideas - chandoo.org/wp/3d-dancing-pendulums/
Can we use Lamda not just for the spreadsheet but for all spreadsheets on my laptop? Just like you can use Personal Macro Workbook to use macros across all files in the laptop?
Right now, LAMBDAs are limited to the workbook in which you write them. By using the free "Advanced Formula Environment" addin by Microsoft, we can export / import lamdbas. I will be adding a video on AFE soon. But do watch this one by Mr Excel - ua-cam.com/video/ySaDkjx3TlI/v-deo.html
Myself sasi iam from India , the content you are providing for power BI is So important to be an industrial ready I just want to know can i know what was the course fee for Indian students
Sir Please make videos in urdu as well because there are a lot of students that don't understand much english so that's why you have to make a urdu channel as well
Substitute simply replaces a character with another. So in this case it replaces all spaces with blanks. So the example is looking at LEN of cell minus LEN of cell where spaces have been removed equals number of characters
Kind of, but more than that. LET allows us to make variables to simplify longer formulas / expressions. LAMBDA will let you create a new function, so you can reuse the logic elsewhere.
mm i think if some1 has knowledge in vba will not use it, since he can create the same with vba and use multiple workbook and if he want to take next level maybe use c Api to get the tool til
Unfortunately, I don't see the value in making any of these examples into Lambdas. I'd like to see a use case for Lambda that cannot be replicated by simply copying the formula into a cell.
Those are my initial thoughts too. But give it a while and LAMBDA will grow on you. Microsoft is adding more horsepower and versatality to the LAMBDA family.
I agree. Simply using LAMBDA as a way to obfuscate formulas seems like a bad business decision. At least in my case, if I were to use something like that, I'd be the only one in the company able to figure out how I did it -- and thus I'd be chained to the spreadsheet forever instead of letting people self-service.
Hmm. I disagree. I didn't demo complex things as they are hard to explain. But you can use LAMBDA along with other Lambda helper functions to create many powerful, optimized and iterative calculations in Excel. Please read chandoo.org/wp/what-is-lambda-function/ for some info and also search up MAP, REDUCE, SCAN, BYROW, BYCOL, MAKEARRAY, TAKE, DROP etc.
Dear Chandoo, Sir, I really liked the way you introduced Lambda in a very simple way and very effective for business situations. Tough made easy. Super Lambda Techniques of your teaching, Sir. Thanks 😊
Thanks Feroz... 😀
I was having trouble copying my
defined Lambda into the naming
Lambda box.
The Ctrl + C and Ctrl + V didn't
work. So I would have to type it out again.
What is going wrong?
@@chandoo_
Absolutely unreal. Programming and naming our own functions in Excel. It's happening!!! Thank you for providing these explanations for these new features. I'm literally going to start using this as soon as I get back to work on Monday.
On another note, as someone who's spent the majority of their life in education, I just wanted to take a moment to praise your ability to break these concepts down in an incredibly concise and easy to understand manner. We need a million professors of your caliber in the states ASAP, please.
Thanks Chris. Excel is a highly capable and versatile software that continues to amaze me and many others.
Thanks also for your lovely testimonial. 😊
This is, for me anyway, one of the most important innovations in Excel in years! Such a simple way to roll your own functions!
I will use this to create severity metrics (dollars/counts). An additional video would be nice to show how to create these functions so they are in every workbook. So they could be added to the workbook when it's created. Thanks!
Sounds like an awesome usecase. There are limited options to share LAMBDAs now. I talk about the "sharing" aspect and compare it with "UDFs" here - chandoo.org/wp/what-is-lambda-function/
Thanks for this explanation and demos. You get me reconsidering my feelings about LAMBDA.
I'd been reluctant because they've been compared to UDFs and I've never needed a UDF. After your video, I'm willing to open my mind and look for possibilities.
Well, now that is WIN in my book. I can't wait to see what cool real-world lambdas you will create and share. 😎
Chandoo, MS has rolled out lambda for all office 365 users. I say this because I am able to use it despite not being an insider...
Good to know this.. 😀😀😀
Thanks Chandoo, this was a great explanation of LAMBDA!
My pleasure Chris...
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.
Vba is sometimes not allowed due security.
Thanks Sir 🙏💕
Mostly used formula n concept in Industry of database n finance, requesting kindly make videos on it.
Because Managers are Asking mostly queries at interview Time.
You are welcome JK. Please watch my recent video on "15 most important formulas for heavy Excel users" here - ua-cam.com/video/B5hayFelHDU/v-deo.html
Excellent examples! Starting off very basic makes it much easier to understand.
Thanks Chandoo!
Doing GREAT 🙏💕 Videos with Awesome Realtime Examples
Love this! Thank you, Sir!🙏
You are very welcome
Great sir, I completely understood the LAMBDA now,
Thanks GK...
Best lambda's explanation, Sir! Do you also have a video about combination of let and lambda? Or just let?
Tomorrow function really awesome chandoo. Thanks a lot.
Just like to know that lambda function uses only two variable or we can use it for more than two variables. Isn't formatting can be used in lambda i.e. converting to date format...
Excellent video.......
You can use any number of variables (including zero). I show all of that in the video.
Unfortunately, we can't yet control the output format with formulas. It might happen in future.
Let's wait for this exciting function I think it can be replacement of LET.
While LET is useful, LAMBDA truly elevates the possibilities.
Great explanation sir 😊👍
Looks exactly like the Python Lambda function. Thanks for the video
It is...
This is great / easy to understand. Unfortunately it is only available in GM On-Line for our company (which for PC does not have the name manager). Great video though and I have been playing around with it.
Amazed as always 😊👍 thanks a million sir 👍
Always welcome
Thanks Chandoo, can't lamda function saved and work on every other workbook open?
I mean once the function is been created, if it could be subsiquently use in other workbooks?
Right now, LAMBDAs are limited to the workbook in which you write them. By using the free "Advanced Formula Environment" addin by Microsoft, we can export / import lamdbas. I will be adding a video on AFE soon. But do watch this one by Mr Excel - ua-cam.com/video/ySaDkjx3TlI/v-deo.html
Hi Chandoo,
Can we create a cube and 3D surfaces, Functions Graph in Excel?
You can use XY plots to make anything. Plus Excel also have 3D options on many of the graphs.
I suggest seeing this for some ideas - chandoo.org/wp/3d-dancing-pendulums/
I saw somewhere that we can do iterations or loops using Lambda... I'm not sure how far that is true but can you please explain about that?
Simple clean explanation
Thanks for liking
thanks chandoo. great explanation
You're most welcome
Super annathey! Thank you very much!
Thanks Sarnath... 😀
and episode 2# Lambda helper functions like:
Map
Reduce
Scan
MakeArray
...
We're looking forward to wathing this tutorial very soon. 🙏
Great suggestion Emre.. I already have plans for these and will be adding videos on the LAMBDA theme in upcoming months.
@@chandoo_ I’m looking forward
Can we use Lamda not just for the spreadsheet but for all spreadsheets on my laptop? Just like you can use Personal Macro Workbook to use macros across all files in the laptop?
Right now, LAMBDAs are limited to the workbook in which you write them. By using the free "Advanced Formula Environment" addin by Microsoft, we can export / import lamdbas. I will be adding a video on AFE soon. But do watch this one by Mr Excel - ua-cam.com/video/ySaDkjx3TlI/v-deo.html
=LAMBDA(a,b,a+b),(2+3) great 👍
A name, build-in functions all you want, and everything what u want replaceable. How i like this type of working like the big software development!
Excel is a BIG Programming World. Most of us don't see it like that...
Right, there's a tremendous volume of abilities in there.
Hi Chandu,
by using the LAMBDA, will we Consolidate Multiple Source Files into a Single worksheet ? If is it possible, please try to explain it
We can't. But you can use Power Query for that. Here is a video on the concept - ua-cam.com/video/SGzegma9bdY/v-deo.html
Can I use vlookup in lembda
Great explanation 👌.. Thanks
You are welcome
Simply awesome brother 👌👌😍
Thanks Navneet... :)
"Very soon Lambda is going to be available in all 365 versions"
I've been hearing that for 2 years!
Haha.. it has been a long wait. But LAMBDA is already here and more will be coming soon.
Myself sasi iam from India , the content you are providing for power BI is So important to be an industrial ready
I just want to know can i know what was the course fee for Indian students
Hi Sasi... Thank you. Please visit chandoo.org/wp/power-bi-play-date/ to see the course fee and details. Email me if you want to enrol right away.
Wow! Game Changer!
Indeed!
Amazing ! Thank you!
Glad you liked it!
Sir Please make videos in urdu as well because there are a lot of students that don't understand much english so that's why you have to make a urdu channel as well
I don't speak Urdu. I suggest using sub-titles to get the concepts. I provide free sample files on all my videos.
Lamba = how to take a simple formula and make it more complicated. I will need to think about this.
I want to make a index match lambda that would be awesome
You can. Or you can also use the XLOOKUP. Which does what Index+Match does with one formula.
See this - ua-cam.com/video/gpwqUc3y7ZA/v-deo.html
Hey!! Chandoo, Thank you for this. But I couldn't understand the "SUBSTITUTE" (word count) function.
Do you have any video regarding that??
Substitute simply replaces a character with another. So in this case it replaces all spaces with blanks. So the example is looking at LEN of cell minus LEN of cell where spaces have been removed equals number of characters
@@CrazyGuy9990 - ahaaann Got it. Thank you :)
Similar to Let?
Kind of, but more than that.
LET allows us to make variables to simplify longer formulas / expressions.
LAMBDA will let you create a new function, so you can reuse the logic elsewhere.
Mr Chandoo, Is there any issue if I use hyperlink function inside Lambda function and define a new name in name manager?
It is not return the link.
I haven't tested it. It could be a limitation of the LAMBDA (or a bug).
So, How can I short a complex excel function (like left+text) by VBA to be short.
mm i think if some1 has knowledge in vba will not use it, since he can create the same with vba and use multiple workbook and if he want to take next level maybe use c Api to get the tool til
Unfortunately, I don't see the value in making any of these examples into Lambdas. I'd like to see a use case for Lambda that cannot be replicated by simply copying the formula into a cell.
Those are my initial thoughts too. But give it a while and LAMBDA will grow on you. Microsoft is adding more horsepower and versatality to the LAMBDA family.
I agree. Simply using LAMBDA as a way to obfuscate formulas seems like a bad business decision. At least in my case, if I were to use something like that, I'd be the only one in the company able to figure out how I did it -- and thus I'd be chained to the spreadsheet forever instead of letting people self-service.
Age calculation
This is just a way to write simple custom functions. For more complex custom functions you'd still need to use VBA.
Check out Excelisfun Lamda examples - ua-cam.com/video/L0KY7pHgudM/v-deo.html, could change your mind
Hmm. I disagree. I didn't demo complex things as they are hard to explain. But you can use LAMBDA along with other Lambda helper functions to create many powerful, optimized and iterative calculations in Excel. Please read chandoo.org/wp/what-is-lambda-function/ for some info and also search up MAP, REDUCE, SCAN, BYROW, BYCOL, MAKEARRAY, TAKE, DROP etc.
@@chandoo_ Then how do you do FOR LOOP and CASE statements with Lambda?
What formulas require a for loop. Can you tell me what you are trying to do?
I don't know who are you, but your look like jony leaver 😄
🤣 Looks like you don't know how to spell *Johnny Lever* is either...
PS: Big fan of Johnny sir...
@@chandoo_ Haa haa yeh