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
The Lamda Function
Thanks Dr Ginhog, this is an interesting alternative to VBA functions.Dr Ginhog wrote: ↑Sat Aug 21, 2021 1:48 pmHi,
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
- MemphisFlash
- Posts: 2161
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
been using that myself for months
-
- 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.
- MemphisFlash
- Posts: 2161
- 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