| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic range where the reference cell can change
Hello
I am trying to make a dynamic range using the OFFSET function, but where the reference cell of this range can change. The following formula works well as long as the reference cell is fixed at test$A$57 =OFFSET('test'!$A$57,1,0,COUNTA('test'!$A:$A)-6 However, as the data are updated, I want the range to start at A58, A59,etc. If anyone can help I would be most grateful. Thank you very much |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dynamic range where the reference cell can change
How (just entered or row inserted) and where (before row 57 or after) is the new data entered. -- Don Guillett Microsoft MVP Excel SalesAid Software "hello" wrote in message ... Hello I am trying to make a dynamic range using the OFFSET function, but where the reference cell of this range can change. The following formula works well as long as the reference cell is fixed at test$A$57 =OFFSET('test'!$A$57,1,0,COUNTA('test'!$A:$A)-6 However, as the data are updated, I want the range to start at A58, A59,etc. If anyone can help I would be most grateful. Thank you very much |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dynamic range where the reference cell can change
Thanks for the reply. The data will be just entered, after row 57.
"Don Guillett" wrote: How (just entered or row inserted) and where (before row 57 or after) is the new data entered. -- Don Guillett Microsoft MVP Excel SalesAid Software "hello" wrote in message ... Hello I am trying to make a dynamic range using the OFFSET function, but where the reference cell of this range can change. The following formula works well as long as the reference cell is fixed at test$A$57 =OFFSET('test'!$A$57,1,0,COUNTA('test'!$A:$A)-6 However, as the data are updated, I want the range to start at A58, A59,etc. If anyone can help I would be most grateful. Thank you very much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut to change change cell reference to Absolute reference? | Excel Worksheet Functions | |||
| Vlookup - dynamic range reference? | Excel Discussion (Misc queries) | |||
| How do I change a cell range with a reference cell? | Excel Discussion (Misc queries) | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| Reference to a dynamic range | Excel Discussion (Misc queries) | |||
Hybrid Mode
