Excel LAMBDA() Function - What is it and when to use it?

PREPARE TO BE AMAZED!!!
LAMBDA() function will change how you use & work in Excel. In this video, let me demonstrate the LAMBDA and its practical applications.
We can use LAMBDA() to create any type of functions in Excel. This revolutionizes the way we work with Excel.
Download the sample file from here 🟩
================================
You need Excel 365 to use LAMBDA. Currently, you also need to enable the "insider" program option, but very soon, you don't need that for LAMBDA.
Learn more about LAMBDA & Get the workbook from here - chandoo.org/wp/what-is-lambda...
In this video ⏱👇
==============
0:00 - What is LAMBDA in Excel?
1:19 - Creating our first LAMBDA
2:27 - Adding LAMBDA functions to Excel
3:53 - Using LAMBDA in real life with 4 examples
4:13 - toEuro() LAMBDA to convert $ values to Euro
6:21 - Weighted Averages with a LAMBDA
9:12 - Word Count LAMBDA
11:13 - Tomorrow() LAMBDA
🤷‍♂️What else is NEW in Excel? 🎁
===========================
It is not your grandpa's Excel any more. There are many POWERFUL & fun new features in Excel now. Check out these videos to learn what else is new in Excel.
1. The # operator in Excel - What is it and how to use it? - • Excel Dynamic Arrays a...
2. FILTER() function changes how you work with data in Excel - • I don’t use filters in...
3. XLOOKUP() function changes how you lookup in Excel • STOP using INDEX MATCH...
4. Power Query changes how you work with data in Excel (simple example) - • Powerful trick to comb...
5. Data model changes how you pivot data in Excel - • Make Pivot Tables from...
Other important features of Excel reviewed - • Top 5 Excel skills you...
#WhatsnewinExcel #lambda
~
What does a young sheep 🐑 call his dad?
Lamb Da Da.. 😂

[@ferozkibria9211]

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 😊

[@chandoo_]

Thanks Feroz... 😀

[@chrisjohnson8687]

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.

[@chandoo_]

Thanks Chris. Excel is a highly capable and versatile software that continues to amaze me and many others. Thanks also for your lovely testimonial. 😊

[@hamishadamson4628]

This is, for me anyway, one of the most important innovations in Excel in years! Such a simple way to roll your own functions!

[@OzduSoleilDATA]

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.

[@chandoo_]

Well, now that is WIN in my book. I can't wait to see what cool real-world lambdas you will create and share. 😎

[@dannynedwich]

Excellent examples! Starting off very basic makes it much easier to understand. Thanks Chandoo!

[@AmySwayzee]

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!

[@chandoo_]

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/

[@chrism9037]

Thanks Chandoo, this was a great explanation of LAMBDA!

[@chandoo_]

My pleasure Chris...

[@jagatkrishna1543]

Doing GREAT 🙏💕 Videos with Awesome Realtime Examples

[@zarniwhite6249]

Love this! Thank you, Sir!🙏

[@chandoo_]

You are very welcome

[@khanabdussabur8604]

Tomorrow function really awesome chandoo. Thanks a lot.

[@ajieapen]

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...

[@chandoo_]

Good to know this.. 😀😀😀

[@generalknowledge5423]

Great sir, I completely understood the LAMBDA now,

[@chandoo_]

Thanks GK...

[@jagatkrishna1543]

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.

[@chandoo_]

You are welcome JK. Please watch my recent video on "15 most important formulas for heavy Excel users" here - kzbin.info/www/bejne/eGbLkqx8mtF7erc

[@ExcelPro.]

Great explanation sir 😊👍

[@agg4390]

thanks chandoo. great explanation

[@chandoo_]

You're most welcome

[@advanced37]

Simple clean explanation

[@chandoo_]

Thanks for liking

[@santyv9466]

Amazing ! Thank you!

[@chandoo_]

Glad you liked it!

[@primeknowledge99]

Amazed as always 😊👍 thanks a million sir 👍

[@chandoo_]

Always welcome

[@arbazahmad7177]

Great explanation 👌.. Thanks

[@chandoo_]

You are welcome

[@smanzoli]

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.

[@sarnathk1946]

Super annathey! Thank you very much!

[@chandoo_]

Thanks Sarnath... 😀

[@Sirigineedi_Navann]

Simply awesome brother 👌👌😍

[@chandoo_]

Thanks Navneet... :)

[@kuldar.]

Best lambda's explanation, Sir! Do you also have a video about combination of let and lambda? Or just let?

[@rohindadina4280]

Looks exactly like the Python Lambda function. Thanks for the video

[@chandoo_]

It is...

[@WiFiJeremy]

Wow! Game Changer!

[@chandoo_]

Indeed!

[@gregbernard7861]

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.

[@canirmalchoudhary8173]

Let's wait for this exciting function I think it can be replacement of LET.

[@chandoo_]

While LET is useful, LAMBDA truly elevates the possibilities.

[@ExcelPro.]

=LAMBDA(a,b,a+b),(2+3) great 👍

[@udaypamphilos]

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?

[@arjit.sharma]

Hi Chandoo, Can we create a cube and 3D surfaces, Functions Graph in Excel?

[@chandoo_]

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/

[@krizvipk]

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.......

[@chandoo_]

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.

[@Bold_Experience]

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?

[@chandoo_]

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 - kzbin.info/www/bejne/r4TEdZ6grZiHoqs

[@coolsg10]

Hey!! Chandoo, Thank you for this. But I couldn't understand the "SUBSTITUTE" (word count) function. Do you have any video regarding that??

[@CrazyGuy9990]

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

[@coolsg10]

@@CrazyGuy9990 - ahaaann Got it. Thank you :)

[@teoxengineer]

and episode 2# Lambda helper functions like: Map Reduce Scan MakeArray ... We're looking forward to wathing this tutorial very soon. 🙏

[@chandoo_]

Great suggestion Emre.. I already have plans for these and will be adding videos on the LAMBDA theme in upcoming months.

[@teoxengineer]

@@chandoo_ I’m looking forward

[@parahiamin6765]

"Very soon Lambda is going to be available in all 365 versions" I've been hearing that for 2 years!

[@chandoo_]

Haha.. it has been a long wait. But LAMBDA is already here and more will be coming soon.

[@gevd5788]

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?

[@chandoo_]

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 - kzbin.info/www/bejne/r4TEdZ6grZiHoqs

[@Munichandra_Reddy]

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

[@chandoo_]

We can't. But you can use Power Query for that. Here is a video on the concept - kzbin.info/www/bejne/iXjdlpqjlp6Vmrs

[@hansklein3649]

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!

[@chandoo_]

Excel is a BIG Programming World. Most of us don't see it like that...

[@hansklein3649]

Right, there's a tremendous volume of abilities in there.

[@kalpeshpanchal7411]

Can I use vlookup in lembda

[@deegadams]

I want to make a index match lambda that would be awesome

[@chandoo_]

You can. Or you can also use the XLOOKUP. Which does what Index+Match does with one formula. See this - kzbin.info/www/bejne/naHaooiZaN5qkKM

[@sasikiran4813]

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

[@chandoo_]

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.

[@Matawfik]

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.

[@chandoo_]

I haven't tested it. It could be a limitation of the LAMBDA (or a bug).

[@Matawfik]

So, How can I short a complex excel function (like left+text) by VBA to be short.

[@catpatlover29]

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

[@chandoo_]

I don't speak Urdu. I suggest using sub-titles to get the concepts. I provide free sample files on all my videos.

[@Glamador]

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.

[@chandoo_]

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.

[@bryan__m]

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.

[@scotolivera8207]

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

[@quinby123]

This is just a way to write simple custom functions. For more complex custom functions you'd still need to use VBA.

[@soniccheese01]

Check out Excelisfun Lamda examples - kzbin.info/www/bejne/gmGuimqmfcyomq8, could change your mind

[@chandoo_]

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.

[@quinby123]

@@chandoo_ Then how do you do FOR LOOP and CASE statements with Lambda?

[@chandoo_]

What formulas require a for loop. Can you tell me what you are trying to do?

[@rahuljamba5846]

I don't know who are you, but your look like jony leaver 😄

[@chandoo_]

🤣 Looks like you don't know how to spell *Johnny Lever* is either... PS: Big fan of Johnny sir...

[@rahuljamba5846]

@@chandoo_ Haa haa yeh

[@DurgaDevi-vr7sr]

Age calculation

[@krutillar]

Lamba = how to take a simple formula and make it more complicated. I will need to think about this.