Excel LAMBDA Recursion + a Trick for Evaluating in a Cell - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Rico
Nice, I like the use of ME, I might try that. The bit I struggle with is how to bail on complex recursive functions, maybe where you've added a counter or whatever. Even in your example, it's not completely obvious how returning 1 in the IF() statement actually causes the function to return 120 (and not 1). That's the bit I struggle with when writing out recursion with more than one parameter, and when let gets involved and so on. I've actually written a couple where I added in another cntr variable, and a text variable that passed back the -state- of variables in the LET function and the counter, so I could effectively see which loop the thing broke on!
reply
Nice, I like the use of ME, I might try that. The bit I struggle with is how to bail on complex recursive functions, maybe where you've added a counter or whatever. Even in your example, it's not completely obvious how returning 1 in the IF() statement actually causes the function to return 120 (and not 1). That's the bit I struggle with when writing out recursion with more than one parameter, and when let gets involved and so on. I've actually written a couple where I added in another cntr variable, and a text variable that passed back the -state- of variables in the LET function and the counter, so I could effectively see which loop the thing broke on!
reply
super
Hey so this is kinda nutty. So I run a warehouse and the WMS we used will not work for a new project we are taking on so I am using Excel. I have 3 sheets, in house inventory, inbound, outbound.
I us a rf scanner and What I am trying to figure out is there a way to scan a into 1 seet and if that same piece number is in my in-house inventory in column b is there a formula to have the item come out of the in-house sheet after i scan thag item into the outbound sheet?
reply
Hey so this is kinda nutty. So I run a warehouse and the WMS we used will not work for a new project we are taking on so I am using Excel. I have 3 sheets, in house inventory, inbound, outbound.
I us a rf scanner and What I am trying to figure out is there a way to scan a into 1 seet and if that same piece number is in my in-house inventory in column b is there a formula to have the item come out of the in-house sheet after i scan thag item into the outbound sheet?
reply
Exce-ambda
Great video!! Happy that you choose factorial sequence, you will see why--.Super neat clever trick to check a recursive before define it !!! -- Very important for recursive formulas is identifying the base case ( for factorial is f(1)=1) and mandatory, an exit condition, ( IF(n
reply
Great video!! Happy that you choose factorial sequence, you will see why--.Super neat clever trick to check a recursive before define it !!! -- Very important for recursive formulas is identifying the base case ( for factorial is f(1)=1) and mandatory, an exit condition, ( IF(n
reply
Johannes
Hello, I have a problem: I'm trying to make a stock price chart show the points at which I've purchased the stock. Would you know how to do this? My attempts fail since the dynamic arrays conflict with each other. Thanks if you'll devote some time to helping.
reply
Hello, I have a problem: I'm trying to make a stock price chart show the points at which I've purchased the stock. Would you know how to do this? My attempts fail since the dynamic arrays conflict with each other. Thanks if you'll devote some time to helping.
reply
Wayne
Hi Mynda. Thanks for this example of using LAMBDA. It feels a bit awkward compared to VBA. Hoping the interface and execution improves soon. Always great learning and fun at MyOnlineTrainingHub :)) Thanks for sharing and Thumbs up!!
reply
Hi Mynda. Thanks for this example of using LAMBDA. It feels a bit awkward compared to VBA. Hoping the interface and execution improves soon. Always great learning and fun at MyOnlineTrainingHub :)) Thanks for sharing and Thumbs up!!
reply
Asghar
Hi, in my excel workbook I have 200+ sheets & sheet names defined.
Every sheet contains data like student name father name address and mob no.s
if I enter sheet name I should get all the data in that particular sheet
reply
Hi, in my excel workbook I have 200+ sheets & sheet names defined.
Every sheet contains data like student name father name address and mob no.s
if I enter sheet name I should get all the data in that particular sheet
reply
Jos-
I really liked the explanation of the possibility of testing the recursive LAMBDA using the LET function -, but this is not very simple to use. --
I inform you that the download file link was missing. -
reply
I really liked the explanation of the possibility of testing the recursive LAMBDA using the LET function -, but this is not very simple to use. --
I inform you that the download file link was missing. -
reply
Geert
That ME parameter must be something special, because defining recursive LAMBDAs as a local variable in LET normally doesn't work in my experience.
Good to know. Thanks.
reply
That ME parameter must be something special, because defining recursive LAMBDAs as a local variable in LET normally doesn't work in my experience.
Good to know. Thanks.
reply
michele
Can i use factorial for obtain a list? For example, if i want a list with all the number, between 5 and 1(4,3,2,1). Once for a Row.
-5-
4
3
2
1
reply
Can i use factorial for obtain a list? For example, if i want a list with all the number, between 5 and 1(4,3,2,1). Once for a Row.
-5-
4
3
2
1
reply
DRSteele
Does the fact you're using LAMBDA cause your cursor to jump down one cell after every entry, forcing you to move it up every time?
reply
Does the fact you're using LAMBDA cause your cursor to jump down one cell after every entry, forcing you to move it up every time?
reply
Add a review, comment
Other channel videos
