| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic Range for Offset
Dear Gurus,
Trying to change the Reference Cell of the Offset funtion, but unfortunately, can not succeed in doing so. For example, 1 2 A 100 30 B 105 43 C 106 45 D 107 21 E 120 45 Trying to find a way to do : Offset(a1,1,0,0,2) - range(100:105) and then offset(b1,1,0,0,4) - range(105:120) then if possible, correl(offset( .XXX. ,1,0,0,2);offset( .XXX. ,1,0,0,2)) Thanks and Regards 2 all Gurus. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range Using INDEX instead of Offset | Excel Discussion (Misc queries) | |||
| Offset function problem-Dynamic range | Excel Discussion (Misc queries) | |||
| Dynamic named range & Offset | Excel Discussion (Misc queries) | |||
| Offset, Dynamic range, Countif | Excel Discussion (Misc queries) | |||
| dynamic range / offset | Excel Worksheet Functions | |||
Threaded Mode
