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

แชร์
ฝัง
  • เผยแพร่เมื่อ 10 ธ.ค. 2024

ความคิดเห็น • 52

  • @PriyankaLiyanage
    @PriyankaLiyanage 4 หลายเดือนก่อน +3

    The best explanation of the LAMBDA function I have seen, especially the recursive LAMBDA. Thank you

  • @stevereed5776
    @stevereed5776 8 หลายเดือนก่อน +1

    The best explanation of the LAMBDA function I have seen, especially the recursive LAMBDA. Thank you

  • @chiengsaby2867
    @chiengsaby2867 หลายเดือนก่อน

    Concise and comprehensive presentation of the intricate concept of lambda especially the recursive feature of this function. Thanks, Sir.

  • @ProgrammingForEveryday
    @ProgrammingForEveryday 3 หลายเดือนก่อน +1

    This is the first time I watch the video and I grabbed everything due to the explanation made easy. thank you so much.

  • @DominicDcruze-o3j
    @DominicDcruze-o3j 8 หลายเดือนก่อน +4

    God bless this man

  • @balakrishnaniyer9782
    @balakrishnaniyer9782 18 วันที่ผ่านมา +1

    Excellent on lambda function. Always be a techie. Very good explanation.

    • @trumpexcel
      @trumpexcel  18 วันที่ผ่านมา

      Glad you found the video helpful 🙂

  • @pratik-i3k
    @pratik-i3k หลายเดือนก่อน +1

    Clear and clean tutorial, thanks

  • @colinhuntley9729
    @colinhuntley9729 4 หลายเดือนก่อน +2

    I certainly agree: the best explanation, which has given me confidence to try the LAMBDA function! many thanks!

    • @trumpexcel
      @trumpexcel  4 หลายเดือนก่อน

      Thank you Colin.. glad the video was helpful in getting a basic understanding of Lambda

  • @mcegirl4
    @mcegirl4 8 หลายเดือนก่อน +1

    I love your videos - you've taught me so much! Your thorough explanations make complex concepts easier to understand.

  • @ajazqudrat45
    @ajazqudrat45 2 หลายเดือนก่อน +1

    Excellent teaching method

  • @neelalam
    @neelalam 8 หลายเดือนก่อน +2

    Very good and effective, also I always like your very clean, clear and optimal presentation.

    • @trumpexcel
      @trumpexcel  8 หลายเดือนก่อน

      Thank you 😊

  • @tlee7028
    @tlee7028 2 หลายเดือนก่อน

    thank you for sharing, your explanation gave me much clarity.

  • @HANSMKAMP
    @HANSMKAMP 2 หลายเดือนก่อน

    12:30 - 13:03 Counting words in a cell can be calculated by breaking the string into an array of strings, by using " " als a delimiter. Then count the number of strings in the array.
    This is done by =COUNTA(TEXTSPLIT(A2;" ")). This is closer to my description above, how to count the number of words. Again. I break the string into an array with TEXTSPLIT which gives an array as a result, and I want to know how many non-empty items are in that array with COUNTA.

  • @canirmalchoudhary8173
    @canirmalchoudhary8173 8 หลายเดือนก่อน +1

    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.

  • @jhankhanajani9314
    @jhankhanajani9314 8 หลายเดือนก่อน

    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.

  • @vishalmittalsvlog4381
    @vishalmittalsvlog4381 8 หลายเดือนก่อน

    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 ❤

  • @chiengsaby2867
    @chiengsaby2867 7 หลายเดือนก่อน +1

    Great explanation! Thanks

  • @daXcel7448
    @daXcel7448 8 หลายเดือนก่อน +3

    =COUNTA(TEXTSPLIT(B2," ")) gives the word count.. A less verbose solution. Thanks for the video!

    • @HANSMKAMP
      @HANSMKAMP 2 หลายเดือนก่อน

      It's closer to my thinking about how to count the number of words in a string.

  • @IvanCortinas_ES
    @IvanCortinas_ES 8 หลายเดือนก่อน

    Thank you Sumit. Great explanation.

    • @trumpexcel
      @trumpexcel  8 หลายเดือนก่อน

      Thanks Iván 🙂

  • @IlaPatel811
    @IlaPatel811 8 หลายเดือนก่อน

    Great explanation, Thanks!

  • @noelgreen6198
    @noelgreen6198 8 หลายเดือนก่อน

    Very good explanation, thank you.

  • @Garimaish
    @Garimaish 8 หลายเดือนก่อน +1

    Very helpful sumit, thanks for sharing

    • @trumpexcel
      @trumpexcel  8 หลายเดือนก่อน

      Thanks Garima... Glad you found it helpful 🙂

  • @info2satish
    @info2satish 5 หลายเดือนก่อน

    Lambda function well explained 🎉

  • @28gurvin
    @28gurvin 6 หลายเดือนก่อน +1

    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 6 หลายเดือนก่อน

      Sorry, I was mistaken, SUBSTITUTE is case sensitive. But if name is also in upper case, the problem highlighted by me will be there.

  • @agnvstosantras8599
    @agnvstosantras8599 6 หลายเดือนก่อน

    More than Perfect. Yes: More and More and More !!!!!

  • @akalarun
    @akalarun 8 หลายเดือนก่อน

    From the accountant point of view how to use lambda function using lamda helper functions like vstack, hstack, textjoin, etc 31:07

  • @HarshilMarwadi
    @HarshilMarwadi 7 หลายเดือนก่อน +1

    Can you explain the recursive lambda function with more examples in another video

    • @trumpexcel
      @trumpexcel  7 หลายเดือนก่อน

      Sure... Will make more on recursive Lambda

  • @abidejaz1090
    @abidejaz1090 8 หลายเดือนก่อน +1

    It's like we are creating functions in different languages like php or c++ and java

  • @ExcelWithChris
    @ExcelWithChris 8 หลายเดือนก่อน

    Loved this. How can I use a Lambda from one file in another file?

  • @gaganwadhwafreelancer
    @gaganwadhwafreelancer 8 หลายเดือนก่อน +1

    Will these lambda formula works there also if i share my workbook with other also

  • @AnshulMarele-gbaa
    @AnshulMarele-gbaa 28 วันที่ผ่านมา

    helpful

  • @cashewABCD
    @cashewABCD 5 หลายเดือนก่อน +1

    Good thing a city like Frankfort isn't in the names list, else it would become Francerankfort.

  • @jastinaligo5369
    @jastinaligo5369 6 หลายเดือนก่อน

    thanks

  • @venkatrooney9912
    @venkatrooney9912 หลายเดือนก่อน

    This loop concept is creating confusion. Can you make seperate viedo for loop

  • @rajan522
    @rajan522 8 หลายเดือนก่อน

    How can we use lookup function using lambda

  • @seenu99250
    @seenu99250 8 หลายเดือนก่อน

    Great.

  • @joukenienhuis6888
    @joukenienhuis6888 8 หลายเดือนก่อน

    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  8 หลายเดือนก่อน +3

      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 8 หลายเดือนก่อน

      @@trumpexcel health is the only asset we need ,stay healthy

  • @ashitshroff
    @ashitshroff 8 หลายเดือนก่อน

    Lambda function requires a basic function. Why would I than add one the Lambda function over the basic function?

  • @surajbhardwaj428
    @surajbhardwaj428 8 หลายเดือนก่อน

    LAMBDA funtion looks powerful.
    But as you showing combination of formula is so complicated 😂
    How can i do this😅😅

    • @trumpexcel
      @trumpexcel  8 หลายเดือนก่อน +1

      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

  • @teoxengineer
    @teoxengineer 4 หลายเดือนก่อน

    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);"")))