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.

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.