Тёмный

Excel Lambda Function (Examples) - All You Need to Know! 

TrumpExcel
Подписаться 374 тыс.
Просмотров 10 тыс.
50% 1

In this video, I show you how to use the LAMBDA function in Excel (with multiple examples).
Lambda function allows you to create your own functions and use them in Excel without using any programming such as VBA or JavaScript.
I will start with some basic examples showing you how to create a Lambda function and then use it in Excel, and then cover some advanced examples.
As the last example, I also covered how to use Recursive Lambdas in Excel (which allows you to loop through cells using a formula by calling a function from within a function)
Download the Example File used in the video - www.dropbox.com/scl/fi/qmvmmr...
Read the article - trumpexcel.com/excel-function...
00:00 Intro
01:04 Creating a Basic Lambda Function in Excel
05:39 Calculate Sales Commission using Lambda Function
11:55 Count Words using the Lambda Function
15:10 Extract Numbers From Text using the Lambda Function
19:21 Recursive Lambda Function in Excel
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Опубликовано:

 

5 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 38   
@PriyankaLiyanage
@PriyankaLiyanage 13 дней назад
The best explanation of the LAMBDA function I have seen, especially the recursive LAMBDA. Thank you
@user-ql5mm8nj8q
@user-ql5mm8nj8q 3 месяца назад
God bless this man
@mcegirl4
@mcegirl4 4 месяца назад
I love your videos - you've taught me so much! Your thorough explanations make complex concepts easier to understand.
@neelalam
@neelalam 4 месяца назад
Very good and effective, also I always like your very clean, clear and optimal presentation.
@trumpexcel
@trumpexcel 4 месяца назад
Thank you 😊
@canirmalchoudhary8173
@canirmalchoudhary8173 3 месяца назад
Nice LAMBDA explanation. One thing I would like to add for recursive LAMBDA is that the calculation part of LAMBDA is as same as standard substitute function. First substitute formula result became text, offset because old text and new text respectively for ReplaceCode formula.
@vishalmittalsvlog4381
@vishalmittalsvlog4381 3 месяца назад
Bhai Dil se thank you. I am MIS but sometimes I stuck I usually watch your video and it helps a lot. Great knowledge and best way to explain. Thank you again ❤
@IlaPatel811
@IlaPatel811 4 месяца назад
Great explanation, Thanks!
@noelgreen6198
@noelgreen6198 4 месяца назад
Very good explanation, thank you.
@chiengsaby2867
@chiengsaby2867 3 месяца назад
Great explanation! Thanks
@daXcel7448
@daXcel7448 4 месяца назад
=COUNTA(TEXTSPLIT(B2," ")) gives the word count.. A less verbose solution. Thanks for the video!
@jhankhanajani9314
@jhankhanajani9314 4 месяца назад
Thank you verry much Sumit!! I have gone through this video in one go and understand the overview of the concept of the Lambda function - it simplifies the working of the formula however I realized, I will need to go through this video multiple times to get command over this kind of function, Very grateful to you for sharing such wonderful video and surprise with, sharing the video on your youtube channel how you manage to send the email also for new video updates.
@info2satish
@info2satish Месяц назад
Lambda function well explained 🎉
@Garimaish
@Garimaish 4 месяца назад
Very helpful sumit, thanks for sharing
@trumpexcel
@trumpexcel 4 месяца назад
Thanks Garima... Glad you found it helpful 🙂
@agnvstosantras8599
@agnvstosantras8599 2 месяца назад
More than Perfect. Yes: More and More and More !!!!!
@IvanCortinas_ES
@IvanCortinas_ES 3 месяца назад
Thank you Sumit. Great explanation.
@trumpexcel
@trumpexcel 3 месяца назад
Thanks Iván 🙂
@seenu99250
@seenu99250 4 месяца назад
Great.
@28gurvin
@28gurvin 2 месяца назад
Such a great way to explain, I always recommend your channel to my contacts for learning basic to advance excel. With 27+ years of my experience in spreadsheets (Lotus123+Excel) I can surely say that your channel is one the top five channels for learning Excel. Keep it up. Just one small query regarding example given, if any name contains the string us, uk, fr, will that part of text will get substituted by full country name, because substitute function is not case sensitive. How to avoid this to happen
@28gurvin
@28gurvin 2 месяца назад
Sorry, I was mistaken, SUBSTITUTE is case sensitive. But if name is also in upper case, the problem highlighted by me will be there.
@jastinaligo5369
@jastinaligo5369 2 месяца назад
thanks
@ExcelWithChris
@ExcelWithChris 4 месяца назад
Loved this. How can I use a Lambda from one file in another file?
@gaganwadhwafreelancer
@gaganwadhwafreelancer 4 месяца назад
Will these lambda formula works there also if i share my workbook with other also
@HarshilMarwadi
@HarshilMarwadi 3 месяца назад
Can you explain the recursive lambda function with more examples in another video
@trumpexcel
@trumpexcel 3 месяца назад
Sure... Will make more on recursive Lambda
@rajan522
@rajan522 4 месяца назад
How can we use lookup function using lambda
@abidejaz1090
@abidejaz1090 4 месяца назад
It's like we are creating functions in different languages like php or c++ and java
@akalarun
@akalarun 4 месяца назад
From the accountant point of view how to use lambda function using lamda helper functions like vstack, hstack, textjoin, etc 31:07
@teoxengineer
@teoxengineer 10 дней назад
Thank you Sumit for this handy tutorial. I hope you will release the second topic, whic is Helper Lambda Functions (Map, Scan, Reduce etc.), and I will follow it 👌 I solved the last your recursive Lamba solution with different way as follow and reached the same result: I have used some new dynamic array formulas like ChooseCol, SplitToText. ConvertToNewName:=LAMBDA(Name;SearchingArray;TEXTTOJOIN(", ";TRUE;CHOOSECOL(SUBSTITUTE(SPLITTOTEXT(Name;" ");",";"");1);VLOOKUP(CHOOSECOL(SUBSTITUTE(SPLITTOTEXT(Name;" ");",";"");2);SearchingArray;2;0);IFERROR(VLOOKUP(CHOOSECOL(SUBSTITUTE(SPLITTOTEXT(Name;" ");",";"");3);SearchingArray;2;0);"")))
@ashitshroff
@ashitshroff 4 месяца назад
Lambda function requires a basic function. Why would I than add one the Lambda function over the basic function?
@joukenienhuis6888
@joukenienhuis6888 4 месяца назад
Wow, I have not seen your videos for a while, but you look great and you have lost weight ! Or am I mixing you with another Excel expert 🤔🧐 I noticed you always write the lambda function in the cell first (and hit enter)before you go to the name manager. Isn’t it easier to go directly to the namemanager and copy the formula and place the text lambda before it?
@trumpexcel
@trumpexcel 4 месяца назад
Welcome back 🙂 Yes, have lost weight and trying to live a more active and healthy lifestyle. Regarding Lambda, I write in a cell as I can test it there and when I am sure it works, I can then add it to Name manager. But that's just how I do it. You can add Lambda to the formula in the Name Manager itself. Also, when creating a video, it's easier for me show people the formula first and in the cell, and when I am done explaining, I can make a Lambda out of it
@suneetbhargava4978
@suneetbhargava4978 4 месяца назад
@@trumpexcel health is the only asset we need ,stay healthy
@surajbhardwaj428
@surajbhardwaj428 4 месяца назад
LAMBDA funtion looks powerful. But as you showing combination of formula is so complicated 😂 How can i do this😅😅
@trumpexcel
@trumpexcel 4 месяца назад
It does take some time to get used to. My suggestion would be to take any big formula you have and convert it into a Lambda. That will give you more ideas on how to use it
@cashewABCD
@cashewABCD Месяц назад
Good thing a city like Frankfort isn't in the names list, else it would become Francerankfort.
@stevereed5776
@stevereed5776 4 месяца назад
The best explanation of the LAMBDA function I have seen, especially the recursive LAMBDA. Thank you
Далее
⚡NEW Excel Functions - TAKE and DROP
10:55
Просмотров 7 тыс.
🤯️ Vini Jr. ✖️ Brahim 🤯
00:13
Просмотров 1,7 млн
ПОМОГЛА НАЗЫВАЕТСЯ😂
00:20
Просмотров 1,4 млн
Schoolboy - Часть 2
00:12
Просмотров 4,9 млн
Excel LAMBDA - HOW & WHEN you Should use it
16:02
Просмотров 431 тыс.
Excel RECURSIVE Lambda - Create loops with ZERO coding!
12:51
Excel LAMBDA Function Tutorial
18:42
Просмотров 65 тыс.
LAMBDA Function in Excel (CUSTOM Excel Formulas 😮)
13:59