Fixed column- Variable row #
Sir,
Thank you for the answer. Unfortunately, the question was posed erroneously.
The proper, entire question appears in this discussion forum under:
"Fixed column, variable rows" and is of yet unanswered.
"RichardSchollar" wrote:
Hi
If you want to name cell Y29 given your value in B8 then you can use
INDEX:
Go InsertNameDefine and name the cell whatever you want, and in the
refers to box type:
=INDEX($Y:$Y,$B$8+5)
This will specify Y29 today (the +5 modifies the B8 value) and
tomorrow, the name will refer to Y30 as the B8 value increments.
Hope this helps!
Richard
Vasilis Tergen wrote:
I need to name a cell, using a fixed column and a a variable row #.
The row # changes every day, and it is the last row of a column of values.
I have the needed row #, resulting as a value in cell B8.
Ex: Today: B8=24. Tomorrow: B8 will be equal to: 25...
Thus, cell B8, will always point to the row # needed= the last row #
containing values.
What I need is to be able to name another cell using cell B8 as a part of a
formula.
Ex: If I wanted to name cell Y29, I'd want to use the value of cell B8(=24;
today...)
as its' row #.
|