alt Hacker NewsExcel excels because if fills the 2D user interface. But not separating calculations from the tabular position in the UI is a historical failure and things like this is a band aid on that
Excel excels because if fills the 2D user interface. But not separating calculations from the tabular position in the UI is a historical failure and things like this is a band aid on that
Having used Framework very extensively at one time, I would say that is one of the best thing about Excel.
OTOH, LAMBDA and LET enable moving the core of some calculations into user defined functions in the Name catalog. And Tables fix a lot of the cell reference issues though they need a lot of improvement to handle array spills.