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.