Forum Discussion
Data Filtering by Column/ Horizontal
I have nothing against LET() in general except it is now only on beta channel. Thus it could be used mainly for modelling purposes, but not on practice for real projects.
My use of LET is pure self-indulgence; though I am particularly interested in developing techniques that exploit the new function. Before installing Office 365, I used to use named formula to bypass the dreaded implicit intersection. That process still works, but it is now more convenient to develop formulas using LET and, also, the parameters are then presented in a logical sequence, so providing self-documenting formulas. Paste Names was all very well but the logic didn't exactly shine through.
For client work, I would clearly not be able to use LET. A contract that required direct referencing and non-array solutions, it would simply turn down; if that is what is want, they can do it themselves 🙂