The Lamda Function

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
Dr Ginhog
Posts: 260
Joined: Wed Nov 03, 2010 12:10 am
Location: Ballygarvan,Cork Ireland T12D2VR
Contact:

Hi,
Just came across this LAMBDA function available to xl 365 users. Apparently can create your own function which you can then call up whenever needed. Helper columns or helper cells would no longer be needed using this. Apparently deals with recursion also which programmers would understand.Here is one of many youtube links on the subject.

https://www.youtube.com/watch?v=Ayc7QOadBa4
tumby
Posts: 32
Joined: Wed Mar 13, 2019 6:49 pm

Dr Ginhog wrote:
Sat Aug 21, 2021 1:48 pm
Hi,
Just came across this LAMBDA function available to xl 365 users. Apparently can create your own function which you can then call up whenever needed. Helper columns or helper cells would no longer be needed using this. Apparently deals with recursion also which programmers would understand.Here is one of many youtube links on the subject.

https://www.youtube.com/watch?v=Ayc7QOadBa4
Thanks Dr Ginhog, this is an interesting alternative to VBA functions.
User avatar
MemphisFlash
Posts: 2127
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

been using that myself for months
Dr Ginhog
Posts: 260
Joined: Wed Nov 03, 2010 12:10 am
Location: Ballygarvan,Cork Ireland T12D2VR
Contact:

Coders like yourselves will understand and make best use of it. My head is still spinning after Excel Guru Leila Gharani's two videos on the subject. She has a comprehensive grasp on her subject. I may have to revisit her videos a few times yet.
User avatar
MemphisFlash
Posts: 2127
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

yes she is very good. kevin strathart is another i use for you tube excel stuff
Dr Ginhog
Posts: 260
Joined: Wed Nov 03, 2010 12:10 am
Location: Ballygarvan,Cork Ireland T12D2VR
Contact:

Thanks Ill check Strathart out.
TBH Gharani covers too much ground too fast for me but she is very smart
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”