Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed column- Variable row #
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 #. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed column- Variable row #
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 #. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 #. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed column- Variable row #
Not in *this* group. Perhaps you are referring to your message in
news:microsoft.public.excel.programming ? -- David Biddulph "Vasilis Tergen" wrote in message ... 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 #. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions |