Finally it clicked on what lambdas can do. I just created my first lambda function for something I do several time day. You have just helped my save soooo much time.
These videos are very helpful, simple and straightforward. You explain clearly what your doing without adding any irrelevant information. Also your names almost the same as mine I'm Benji :D
Super nice explanation of what lambdas are! Easy to grasp, and recreatable . But a little but, that has less to do with the lambda and more with your last step. Whilst I think the search field is super handy for very big data tables with many options, I would actually connect this with your lessons for dropdowns and the # . I just generally mistrust people to spell things correctly, and rather turn around and complain something isn’t working than check their own fallacy. So I take away the potential for mistakes by creating a field in an open area of the sheet or a new sheet with the formula =unique(Table[region column] Creating all unique and hence possible options for the filter and then reference to that field in the data validation with a #
Be careful using Lambda, especially recursively. I built an engineering model, part of which was to calculate additional battery strings required by several solution sets to ensure variable carry over times were met. It didn't scale as the number of solutions modelled expanded. No such scaling trouble with Powerquery or VBA, both of which are really well supported by AI.
Thank you for explaining the LAMBDA function, but everything you showed its also manageable by converting the data into a table, which can provide more filter and sort options. What are your thoughts?
Are the LAMBDAS reusable? I don't really understand the point of them if you have to go and create the formula first - you've already done the work anyway. Can you help me wrap my brain around it?
Hi thank you for your interest. I think the Excel for business & finance course is a nice starting point for you: www.careerprinciples.com/courses/excel-for-business-finance For any other questions you can ask info@careerprinciples.com 👍
🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/933u
❤❤❤❤❤❤
Finally it clicked on what lambdas can do. I just created my first lambda function for something I do several time day. You have just helped my save soooo much time.
Thank you. It means a lot to me😀
Wow, Kenji. I didn't know lambda and it just blowed my mind!! Thank you very much!!
Great to hear that!
These videos are very helpful, simple and straightforward. You explain clearly what your doing without adding any irrelevant information. Also your names almost the same as mine I'm Benji :D
Thank you for your nice comment Benji! Yes haha they often confuse mine for Benji XD
Super nice explanation of what lambdas are! Easy to grasp, and recreatable .
But a little but, that has less to do with the lambda and more with your last step. Whilst I think the search field is super handy for very big data tables with many options, I would actually connect this with your lessons for dropdowns and the # .
I just generally mistrust people to spell things correctly, and rather turn around and complain something isn’t working than check their own fallacy.
So I take away the potential for mistakes by creating a field in an open area of the sheet or a new sheet with the formula =unique(Table[region column]
Creating all unique and hence possible options for the filter and then reference to that field in the data validation with a #
3:15 Lookup functions also work!
Thanks Kenji you are a life savior God Bless you
"First like and first comment! I’m truly impressed by all your videos, sir. 🙏"
Thank you! Really appreciate it :)
Ive never heard of this. You are brilliant!
Made lamda really easy to follow along. Thanks!
Great explanation. Thank you, Kenji!!!
13:53 In this case, you should modify it so you can do a wildcard search.
Excellent video!
7:39 Question: What is the "by_col" argument of the SORT() function?
Thanks.
can you do more advanced cases of Lambda?
Noted!
Really helpful video!! Thanks Kenji
Kenji, thanks for that! Cool!
Nice ,easy to understand
Excellent ❤😊
Be careful using Lambda, especially recursively. I built an engineering model, part of which was to calculate additional battery strings required by several solution sets to ensure variable carry over times were met. It didn't scale as the number of solutions modelled expanded. No such scaling trouble with Powerquery or VBA, both of which are really well supported by AI.
Great sir
impressive that as well as being an excel-expert, you speak very good german!
Well done!
Thank you kenji
Thank you
Thank you for explaining the LAMBDA function, but everything you showed its also manageable by converting the data into a table, which can provide more filter and sort options. What are your thoughts?
Can I carry this across my worksheets?
Qual a vantagem de usar o LAMBDA em vez de usar um módulo VBA para isso?
Can this formula be applied to Excel on different devices? Or does the formula have to be created first? Terimakasih
Hey, how can i use flatten function in Excel (two or multiple columns into one column)
Are the LAMBDAS reusable? I don't really understand the point of them if you have to go and create the formula first - you've already done the work anyway. Can you help me wrap my brain around it?
They are reusable indeed
I was just thinking the exact same thing
Hello, I want to learn excel (just because I like it) which of your courses do you recommend. My level will be like basic-intermediate. Thank you
Hi thank you for your interest. I think the Excel for business & finance course is a nice starting point for you: www.careerprinciples.com/courses/excel-for-business-finance
For any other questions you can ask info@careerprinciples.com 👍
Thanks, can i add some helper definitions to these custom functions?
I dont see a practical use for this, can anyone suggest what purpose this can serve?
Lambda = PEMDAS and the Alphabet got merged like Jeff Goldblum in The Fly.
WHEN I DOWNLOAD VIDEO THE AUDIO IS NOT ENGLISH WHAT TO DO
th-cam.com/video/zVyJCCk0sTY/w-d-xo.html