| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Offset function and Dynamic Ranges
I just saw an example of this formula in an online newsletter:
=OFFSET(Data!$A$1,0,0,COUNTA(Data!$A$1:$A$19),COUN TA(Data!$1:$1)) I was trying it out and noticed that you have to place it with the upper left cell in cell A1 of a worksheet for it to reproduce the data that it refers to. Otherwise the #VALUE error appears. This is not how the OFFSET function usually works for me and it seems to have something to do with the COUNTA function appearing in the height and width arguments. I usually don't use the height and width arguments at all. Could someone explain why this is so and if there is a way to overcome this restriction? Thanks for your help, Sandy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dependent drop down boxes and dynamic ranges | Excel Worksheet Functions | |||
| Solver and dynamic ranges | Excel Worksheet Functions | |||
| Dynamic Function Reference Question | Excel Discussion (Misc queries) | |||
| dynamic offset | Excel Discussion (Misc queries) | |||
| dynamic ranges | Excel Worksheet Functions | |||
Threaded Mode
