Forum Discussion
Access Analytic Power Query challenge: Ticket list
PeterBartholomew1 I didn't check details, as a comment - if we speak about "modern Excel" now it assumes Automation (Excel Scripts), not lambdas. However, even functions like MAXIFS() would be considered as "modern" for a long while.
I accept that 'modern' is ill-defined and open to multiple interpretations. It is also somewhat emotive if used as an antonym for 'obsolete', 'legacy' or even 'traditional'; all slightly pejorative terms (I am not sure how this translates into Russian).
I tend to think of Excel as the core functional programming on a two-dimensional grid as being part of the wider ecosystem that includes VBA, Scripts, Power Query, Power Pivot etc. What LET and LAMBDA have the potential to do is change the nature of that core functionality out of all recognition. Instead of a highly interactive environment in which 'muscle memory' has a larger part to play than abstract thought, to something in which the programming element is far more to the fore. When one combines my preferences for names (over direct referencing by sheet location) with some of the layout techniques I learnt from you, it is not uncommon for the OP not even to recognise the solution to their problem as being Excel. It is that change that I am attempting to describe. I am open to other suggestions.