Excel LAMBDA Recursion + a Trick for Evaluating in a Cell

Mynda, you have a great way of taking something complex and making it simple to understand, Can you please do the same with the ME parameter?

you are the best 'teacher', Mynda, out of all MVPs

Wasn't familiar with the ME functionality. Thanks Mynda, a good push in the right direction.

Excel has become a functional programming language lol

Another way to do this is as below...

Assuming the number is in A2, then to find the factorial of the number in A2, we may use the following formula directly in the cell.
In B2
=REDUCE(1,SEQUENCE(A2),LAMBDA(n,r,n*r))

Also they need to come up with a solution for the argument IntelliSense, otherwise, in my opinion, VBA UDF is still better especially that it is application level

Your explanations, presentation and instructions are very good and interesting. Thank you for sharing excel tips this way. IAM sure many people like get to learn from your videos. Thank you..

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.

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.

can u help me

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!!

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

🤯 I shouldn't be watching these kind of videos before going to sleep.

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

Great example! LAMBA could replace some VBA scripting so it's good to know

Great content!

Appreciate your efforts

Thank you for this tutorial Mynda. I am already waiting this function in my Excel 365. That's a very powerful function!

Hi Mynda!Great Tutorial.Very Interesting Plus Nice And Easy To Understand...Thank You :)

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. 😊

Mynda there is no link to download the excel file

Thank you for this amazing video

Hi there, i don't see the download link

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?

Wow. Time for an Advil, Mynda!

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!

Keeping track of the exit strategy and testing recursion are very hard. Great stuff

As you said: "mind bending"! :D