I have a spreadsheet that has about 16 equations that use ranges.
I want to be able to copy the data and equations for multiple runs of the data. With different runs of the data, the ranges are different.
Rather than edit the ranges in 16 equations, I would like to put the range in a single cell that is used by all the equations. Then I can just edit the range once.
Named Ranges don't really help because when I copy the set of equations, the named ranges are copied too, and I have to edit all 16 of them to different ranges, as well as create new named ranges for each instance of the data.
The INDIRECT function doesn't help because it takes a string as input, not a range.
Ideally, I could put a range in cell X123, and edit it using the normal range specification techniques. In my equations I would just put =Average(!X123), if ! was the magical indirect operator, and the equation would provide the average of the cells in the range contained in X123.
Is there a good way to accomplish this?