I picked up yesterday that Excel 2021 will have LAMBDA and LET functions. It seems very interesting for all of us challenged by VBA coding. From what I can grasp the LAMBDA function allows the user to create custom functions in Excel using basic Excel inputs ... no VBA! It also allows the custom function to call itself! What? Yep, call itself and that means you can set up 'loops'.
There are already many Youtube video and Excel help website reviews, try this one as an example. As one guy in another video says he has never known so many videos and function reviews to be published within a few days of the beta release, some describe it as one of the most important releases ever.
As well as the obvious functionality it provides it also speeds up execution because the formula is only stored once and not repeated in every cell. I think after some analysis of it's power it will help non VBA users significantly.
I understand it is expected to go on general release later this year. Have fun.
