Thank you Nabil for all you intense effort to make such appealing graphics, you eloquent narration and for waving your 'Magic Wand' to make the complex appear simple. The videos you make are always very interesting. Looking forward to many more of your videos.
Our teacher, Nabil Murad, you made the excel program a pleasure and you became better watching one of your channel’s videos than watching a movie or watching TV .. Thank you for the wonderful preparation, interesting presentation, graceful language and great direction ... You made me very happy ... Many thanks and Respect ,,,
Very interesting and such a good example to illustrate the usefulness of the LAMBDA() function. I look forward to the link example workbook to be posted so I can follow along step-wise. Thanks!
Excellent explanation Nabil. I have to review the whole process with peace of mind. I think the new Lambda function helps the second user, or end customer, to better understand the process. As for the creator of the process, it simply brings order, but has to do redundant work, because the work already worked well before! A question. Once the function is created, can it be used in different books? Thank you very much for telling us all the details!
There is so much to learn in excel, this software alone is a university degree on its own. Once you master it you will discover amazing things. It can organise your life
Thank you, Nabil, for this clear explanation using a complex example. *** I realize that your purpose is explanation of LAMBDA (mission accomplished), but also think that you could write this to incorporate the INDEX statement which would further simplify the user’s implementation in the workbook. Something along the line of: fctGetValue(vSourceRange, vIndex, [formula]). *** I use LET extensively & see the greatest value of LAMBDA as simplifying the user’s ability to audit & maintain/update functions that are used in multiple instances in the same workbook. That will be extremely helpful for my applications where I develop workbooks, release them for use, then return to them in 12-18 months when something breaks, the inputs change, &/or functional requirements change. LET & LAMBDA will make that come-back-to-it-later review so much easier, especially as advancing age takes its toll. *** I’m aware that LET & LAMBDA can be used together, but I anticipate that I’ll use LET for functions that are used once in a workbook & LAMBDA for functions used more than once. (I’ll also use LET within LAMBDA to make complex functions easier to understand.) *** Now, my big problem: what standard prefix will I use for LAMBDA functions? 😉 I use fct for VBA functions, fx for Power Query functions; what should I use for LAMBDA? *** Thanks again for this great tutorial.
Hi Jim, totally agree with what you said. I definitely have the intention of creating another tutorial where i nest the LET into the Lambda and call another Lambda from within a Lambda, something that will be much more complex than this tutorial. Thanks for sharing your experience and ideas.
Good work Nabil. This lambda function is similar to LET function so what is the distinction? I'm an officer insider but how do I create the lambda function I want to practice.
The Lambda Function can have one or multiple nested LET functions, as well as other LAMBDA functions. Unlike the LET, it can be saved as a custom function and you can use it like any built-in function
Thanks, easy explanation, But I think this issue is not a good example for LAMBDA function. For this challenge it's better to use Let function as bellow in one formula. =LET( name,INDEX(A:A,SEQUENCE(COUNT(C:C),,3,3)), family,INDEX(A:A,SEQUENCE(COUNT(C:C),,2,3)), Fname,name&" "&family, region,INDEX(B:B,SEQUENCE(COUNT(C:C),,4,3)), amount,INDEX(C:C,SEQUENCE(COUNT(C:C),,3,3)), CHOOSE({1,2,3},Fname,region,amount))
LET function is a great function No doubt. Note that my goal is to teach the concept of a new function to millions of viewers in a simple way (as much as I can). I will definitely create much more advanced examples of the Lambda function with nested LET functions. When introducing the new function, Microsoft gave us the simplest example you can imagine: =Lambda(x,y,x+y). I tried to create something a little bit more interesting. I spend few minutes thinking of the example and long hours thinking how to explain it in a very smooth way. Anyway, I appreciate your valuable contribution.
@@Officeinstructor You are great. Appreciate it. I watched your other tutorials and really amazed. Just I wanted to give you a feed back since if we use new function in an example that will not solve with other solutions as easy as it is, will be better. Anyway I really liked your tutorials. Thumbs up.
Can you give us must more basic examples on lambda.. to understand this you got to be already at advanced level. Give us some small examples and we can build on that.
I have made the updates and *lambda* is still not found (365, Windows). I read from some sources that they give it first to some users and eventually it is given to everybody. This isn't fair. What is this all about?
Again and again, amazing teacher; easy to follow, well paced and insightful.
Thank you so much. Glad you liked it
Most revelatory exposition of the Lambda function I've seen. Wow, the use of context and steps is superb!
While others just show the new function with x,y and x+y, you showed a comprehensive, functional, everyday-use example.And that is why I'm subscribed!
You can't imagine after the INCREDIBLE effort I put in my videos, how much such encouraging comments make me Happy. Thank you Alex
Very Good and Well Explained. Thanks Mr. Nabil. Your contributions to the Community are very appreciated!.
Thank you Nabil for all you intense effort to make such appealing graphics, you eloquent narration and for waving your 'Magic Wand' to make the complex appear simple. The videos you make are always very interesting. Looking forward to many more of your videos.
So nice of you
Our teacher, Nabil Murad, you made the excel program a pleasure and you became better watching one of your channel’s videos than watching a movie or watching TV .. Thank you for the wonderful preparation, interesting presentation, graceful language and great direction ... You made me very happy ... Many thanks and Respect ,,,
Thank you very much Yousry, it's a great pleasure to read your feedback and have you as a member of the OfficeInstructor channel
Very very nice your my favorite tutorial Teacher for excel 👍👍👍👍👍
Thank you so much Ricardo for the nice comment. It's a pleasure to have you in my channel.
Wow - such a clear explanation of why we might want to use lambda. Thank you Nabil
You are most welcome
Your a Genius, and a great teacher. That's a rare combination.
Wow, thanks!
Nabil this is fantastic ... Previously I had given up when dealing with over a 1000 records but now there is a solution. Thank you, its fantastic
Glad you like it Neren.
Thanks for watching
Nabil, you are just awesome, no words, an excel legend. Thanx a lot for such an informative and useful post.
A great video from a great teacher.
Thanks Nabil . Salim from Hamburg.
Thank you Salim
@@Officeinstructor Thumbs up. I will try all these steps on my own PC إن شاء الله..
Must see this video again.
Genius is like a database but in excel well done, no stupid music and slow explanation thank you sir.
You are most welcome Luis
Absolutely brilliant, well paced and clear explanation with so many extra nuggets of information during the demonstration. Bravo!
Very well explained. Thanks for another excellent tutorial. Thanks Nabil!👏👏👏
Always welcome
Very well explained Nabil. Thank you for this amazing video 📹 👍
Amazing video tutorial. The use-case is very apt. You're very explicit in your teaching as always. Thanks for sharing
Thank you my friend for the nice words and motivation (as always)
@@Officeinstructor Trust me it's devoid of flattery. I've learned so much on Excel from you and you're an amazing teacher. Keep shining your light
Excellent explanation and demonstration. Mumtaz
Very interesting and such a good example to illustrate the usefulness of the LAMBDA() function. I look forward to the link example workbook to be posted so I can follow along step-wise. Thanks!
Done!
Check the link in the video description
🎉👏
Brand new & revolusioner function.
Thank you Sir!
You are welcome!
Amazing, Nail. Just amazing. 💥💥💥
Thank you so much my friend.
Totally appreciated Oz Du Soleil
Magnificent, Bravo👍🏼
Thank you
Clear explanation, thank you sir!
Masha'Allah superb explanation
Thanks and welcome
Thank you 👍
You are Welcome
شرح واضح ومميز جدا
مشكور استاذ / نبيل مراد
Thank you my friend Saad
Excellent explanation Nabil. I have to review the whole process with peace of mind. I think the new Lambda function helps the second user, or end customer, to better understand the process. As for the creator of the process, it simply brings order, but has to do redundant work, because the work already worked well before!
A question. Once the function is created, can it be used in different books? Thank you very much for telling us all the details!
There is so much to learn in excel, this software alone is a university degree on its own. Once you master it you will discover amazing things. It can organise your life
Thank you, Nabil, for this clear explanation using a complex example. *** I realize that your purpose is explanation of LAMBDA (mission accomplished), but also think that you could write this to incorporate the INDEX statement which would further simplify the user’s implementation in the workbook. Something along the line of: fctGetValue(vSourceRange, vIndex, [formula]). *** I use LET extensively & see the greatest value of LAMBDA as simplifying the user’s ability to audit & maintain/update functions that are used in multiple instances in the same workbook. That will be extremely helpful for my applications where I develop workbooks, release them for use, then return to them in 12-18 months when something breaks, the inputs change, &/or functional requirements change. LET & LAMBDA will make that come-back-to-it-later review so much easier, especially as advancing age takes its toll. *** I’m aware that LET & LAMBDA can be used together, but I anticipate that I’ll use LET for functions that are used once in a workbook & LAMBDA for functions used more than once. (I’ll also use LET within LAMBDA to make complex functions easier to understand.) *** Now, my big problem: what standard prefix will I use for LAMBDA functions? 😉 I use fct for VBA functions, fx for Power Query functions; what should I use for LAMBDA? *** Thanks again for this great tutorial.
Hi Jim, totally agree with what you said. I definitely have the intention of creating another tutorial where i nest the LET into the Lambda and call another Lambda from within a Lambda, something that will be much more complex than this tutorial. Thanks for sharing your experience and ideas.
What an amazing function. Will lambda, sequence, filter be available for office 2019? Most of the users don't have office365.
Good work Nabil. This lambda function is similar to LET function so what is the distinction? I'm an officer insider but how do I create the lambda function I want to practice.
The Lambda Function can have one or multiple nested LET functions, as well as other LAMBDA functions. Unlike the LET, it can be saved as a custom function and you can use it like any built-in function
@@Officeinstructor so how do I get the function from insiders I'm already an insider.
Lambda is time saving ,only once your time invested in to make basic formula and than after enjoy the show of LAMBDA.
That's great
Thanks, easy explanation,
But I think this issue is not a good example for LAMBDA function.
For this challenge it's better to use Let function as bellow in one formula.
=LET(
name,INDEX(A:A,SEQUENCE(COUNT(C:C),,3,3)),
family,INDEX(A:A,SEQUENCE(COUNT(C:C),,2,3)),
Fname,name&" "&family,
region,INDEX(B:B,SEQUENCE(COUNT(C:C),,4,3)),
amount,INDEX(C:C,SEQUENCE(COUNT(C:C),,3,3)),
CHOOSE({1,2,3},Fname,region,amount))
LET function is a great function No doubt. Note that my goal is to teach the concept of a new function to millions of viewers in a simple way (as much as I can). I will definitely create much more advanced examples of the Lambda function with nested LET functions.
When introducing the new function, Microsoft gave us the simplest example you can imagine: =Lambda(x,y,x+y). I tried to create something a little bit more interesting. I spend few minutes thinking of the example and long hours thinking how to explain it in a very smooth way.
Anyway, I appreciate your valuable contribution.
@@Officeinstructor You are great. Appreciate it. I watched your other tutorials and really amazed.
Just I wanted to give you a feed back since if we use new function in an example that will not solve with other solutions as easy as it is, will be better.
Anyway I really liked your tutorials.
Thumbs up.
Wow!
!!
Is this available in Excel for Mac, I can't seem to find it
Can you give us must more basic examples on lambda.. to understand this you got to be already at advanced level. Give us some small examples and we can build on that.
waiting for Exercise File !!!
Done!
Check the link in the video description
I have made the updates and *lambda* is still not found (365, Windows). I read from some sources that they give it first to some users and eventually it is given to everybody.
This isn't fair. What is this all about?
روعة مراد استمر
Can we change ur name to "Nabil Magician Mourad"
Thank you my friend... That's very nice of you. I'm glad you enjoyed the video.