| 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 |
| 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) | |||
Threaded Mode
