Hi David. Great video! Thanks for sharing your LAMBDAs and demonstrating how to set up and use the Advanced Formula Environment. Looks like fun and lots to learn :)) Thumbs up!!
David, thank you very much for showcasing these examples. Have you shared this video on LinkedIn yet? I would love to look at the functions you built to start learning more and contribute to the community.
Since many people made LAMBDAs in Beta and many others will make more now that it’s released… Microsoft needs to do something like Lego does with their Lego ideas. Basically if a lambda were to get so many votes, they would end up adding it to actual excel at some point. Lego does modify certain things sometimes so Microsoft could too
That’s a good idea! Yeah, they could build it into the process but for now it’s useful to share useful lambdas in like a store of sorts, GitHub is a bit intimidating still
Hi, I'm from Brazil, I discovered this supplement a month ago, but I couldn't understand the explanation. how the editing of the lines works there in the Advanced Formula Environment editor so I created a lambda formula it calculates the BMI the body mass of a person =LAMBDA(HEIGHT; WEIGHT; WEIGHT / (HEIGHT^2)) how do i enter the lines in the Advanced Formula Environment editor?
Does anyone has an idea how to make improved WORKDAY function that has atribute for working Saturdays or Sundays? Something like opposite to holiday atribute: you just make list of working weekend days, and reference that list into the improved WORKDAY function... =WORKDAY(start date, working days, [holiday], [WORKING WEEKENDS DAYS])
if anyone is interesting in, I find solution: =LAMBDA(start_day,number_of_working_days,list_holiday,list_working_weekends, WORKDAY(start_day, number_of_working_days-COUNTIFS(list_working_weekends,""&start_day), list_holiday))
thanks for the very energenic tutorial. you are really inspiring! and your sharing is also much appreciated!
Wow that’s so kind!!! Glad you found it useful 😃
Hi David. Great video! Thanks for sharing your LAMBDAs and demonstrating how to set up and use the Advanced Formula Environment. Looks like fun and lots to learn :)) Thumbs up!!
Sure! Glad you find it useful 😃
Thanks, David for the Lamdas demo. I would like to have access to the file too.
Sure you can email me to david@xlconsulting-asia.com & I can share
David, thank you very much for showcasing these examples. Have you shared this video on LinkedIn yet?
I would love to look at the functions you built to start learning more and contribute to the community.
Heya! Glad you like it. Yes I have shared on linked in… what else would you like to see?
Hello David. Very helpful video. Can you please send the link to the lambdas you created.
Hi yes sure email me & I can share them on david@xlconsulting-asia.com
David, I enjoyed the information in your video. Please let me know how i can get copies of the Lamdas that were showcased.
Glad to hear it! Sure just email me to david@xlconsulting-asia.com & subscribe!
Thanks David
Glad you like it!
Great video! Thanks!
Glad you like it!
Since many people made LAMBDAs in Beta and many others will make more now that it’s released…
Microsoft needs to do something like Lego does with their Lego ideas. Basically if a lambda were to get so many votes, they would end up adding it to actual excel at some point. Lego does modify certain things sometimes so Microsoft could too
That’s a good idea! Yeah, they could build it into the process but for now it’s useful to share useful lambdas in like a store of sorts, GitHub is a bit intimidating still
May I please have the codes too? very good video thank you.
Sure! Glad you like it. Just email to david@xlconsulting-asia.com & subscribe!
Hi, I'm from Brazil, I discovered this supplement a month ago, but I couldn't understand the explanation.
how the editing of the lines works there in the Advanced Formula Environment editor so I created a lambda formula it calculates the BMI the body mass of a person
=LAMBDA(HEIGHT; WEIGHT; WEIGHT / (HEIGHT^2))
how do i enter the lines in the Advanced Formula Environment editor?
If you go to the editor, then add a new function & paste it should work! In my video I go through how to add or edit something there
When I save the template file in the start up folder, does not work for me, the UDFs will not show in new file even after closing, and using Ctrl N.
Hi sorry to hear that, it’s quite complex what is going on with the file, I can’t help just from a short explanation
Yes please can I have!
What would you like? My LAMBDA equations?
Does anyone has an idea how to make improved WORKDAY function that has atribute for working Saturdays or Sundays?
Something like opposite to holiday atribute: you just make list of working weekend days, and reference that list into the improved WORKDAY function...
=WORKDAY(start date, working days, [holiday], [WORKING WEEKENDS DAYS])
if anyone is interesting in, I find solution:
=LAMBDA(start_day,number_of_working_days,list_holiday,list_working_weekends,
WORKDAY(start_day,
number_of_working_days-COUNTIFS(list_working_weekends,""&start_day),
list_holiday))
Cool! Very useful 😃