Forum Discussion
How to make changes ranges in an array/formula without manually modifying it each time
When I copy/paste data into a spreadsheet, the array below looks at ranges in columns O and B. However, the next time I copy/paste data in the columns may be different.....column O and A, or H and L....
PeterBartholomew1 - yes, agree. Named ranges/formulas in general are not very popular, even tables which in some extent could be considered as dynamic named ranges.
I would consider tables as the ideal way of holding the initial input and reference data for a model. My aim when developing a solution is to capture as much structure as I can within the solution and, also, to link it as tightly as possible to the terminology and assumptions of the application domain.
That rather contrasts with the normal 'tips and tricks' genre aimed at achieving (bad?) solutions faster. Speed is good but it should not be the main objective.