R
Robert Peirce
OK. I said that wrong.
Assume A1 contains a line number, say 27. Your formula wants to access
column X and it needs to know the last entry in column X, which is X27.
Suppose you have many columns that all reference the last data line and
it is 27 in every case.
What I want to do is kind of an indirect reference. Instead of saying
X27, I want to say X<contents of A1>. That way, when I add the 28th row
of data, instead of changing all the formulas I just need to change A1
to 28.
Note, in many cases, adding a new line will increment the formula, but
not in the case I am working with. In this case I have to actually
change each formula, and I really need a way around that.
Assume A1 contains a line number, say 27. Your formula wants to access
column X and it needs to know the last entry in column X, which is X27.
Suppose you have many columns that all reference the last data line and
it is 27 in every case.
What I want to do is kind of an indirect reference. Instead of saying
X27, I want to say X<contents of A1>. That way, when I add the 28th row
of data, instead of changing all the formulas I just need to change A1
to 28.
Note, in many cases, adding a new line will increment the formula, but
not in the case I am working with. In this case I have to actually
change each formula, and I really need a way around that.