| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic Range in Offset Help Request
Dear Gurus and MVPs,
Is there a way to change the Reference of the Offset funtion so that the reference cell could change accordingly ? For example, 1 2 A 10 21 B 11 22 C 12 23 D 13 24 Correl(offset(a1;1;0;2);offset(a2;1;0;2)) in a generalized way, Correl(offset( x1 ;1;0;k);offset( x2 ;1;0; k ) is possibe ? x1=a1,b1,c1 ... k=1,2,3 ... Thank you for your time and help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dynamic Range in Offset Help Request
see your other post
-- Biff Microsoft Excel MVP "VBApprentice :)" wrote in message ... Dear Gurus and MVPs, Is there a way to change the Reference of the Offset funtion so that the reference cell could change accordingly ? For example, 1 2 A 10 21 B 11 22 C 12 23 D 13 24 Correl(offset(a1;1;0;2);offset(a2;1;0;2)) in a generalized way, Correl(offset( x1 ;1;0;k);offset( x2 ;1;0; k ) is possibe ? x1=a1,b1,c1 ... k=1,2,3 ... Thank you for your time and help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range for Offset | Excel Worksheet Functions | |||
| Dynamic Range Using INDEX instead of Offset | 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 | |||
Linear Mode
