Forum Discussion
Excel large, n=2 and n=3 return the same value.
Detlef_Lewin yes, that's better solution, I just mapped pre-DA approach
My preference is to give up non-DA development altogether.
The last resort is to charge the client an extra grand and provide a computer and 365 license to go with the solution workbook!
Look, with millions of users who don't want or can't afford to buy new computers and licenses we always have to find some compromise. Excel is the behemoth in software world with it's own rules of behaviour.
I am not suggesting that others should follow the same path. I came to dislike the idea of direct cell referencing in principle since, to me, the location of a value or formula on a sheet has no bearing as to its significance. I had gravitated to using named ranges and CSE array formulas most of the time despite the fact that Excel was heavily optimised for a far more interactive way of working.
Now with DA I am free to think and work in a manner that has always been more natural for me; after all, my day job was entirely built on 'matrix methods'. Equally, I accept that many of the financial modellers I meet prefer to copy individual values repeatedly so that they are close to the each formula that references them; parts of the Standard are 'Do not use Names' and 'Do not use Array Formulas'.
They are perfectly free to go their way, whilst I (thankfully) depart in an entirely different direction. There are many 'gurus' that can support traditional working but few, like you, that can do both.
