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
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.
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 #
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?
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 👍
Does the name manager save to the file or to your local excel? I am wondering if it works if someone on a different PC opens up the shared file will it have any issues working?
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?
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.
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/933u
❤❤❤❤❤❤
BOSS I WANT TELL YOU
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
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!
"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!
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 #
can you do more advanced cases of Lambda?
Noted!
Really helpful video!! Thanks Kenji
Great explanation. Thank you, Kenji!!!
Thanks Kenji you are a life savior God Bless you
Excellent video!
Made lamda really easy to follow along. Thanks!
3:15 Lookup functions also work!
Kenji, thanks for that! Cool!
Nice ,easy to understand
Excellent ❤😊
Well done!
Great sir
7:39 Question: What is the "by_col" argument of the SORT() function?
Thanks.
13:53 In this case, you should modify it so you can do a wildcard search.
impressive that as well as being an excel-expert, you speak very good german!
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?
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 👍
Qual a vantagem de usar o LAMBDA em vez de usar um módulo VBA para isso?
Does the name manager save to the file or to your local excel? I am wondering if it works if someone on a different PC opens up the shared file will it have any issues working?
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
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.
Can user-created functions using LAMBDA be used across workbooks?
Hi- couldn't get your spreadsheet to work correctly in Office365
I dont see a practical use for this, can anyone suggest what purpose this can serve?
Thanks, can i add some helper definitions to these custom functions?
LAMBDA is not on my excel
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
ruclips.net/video/zVyJCCk0sTY/видео.html