Dynamic Range in Offset Help Request

V

VBApprentice :)

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Range for Offset 8
use offset function 4
Dynamic reference in OFFSET function 1
Dynamic Range Using INDEX instead of Offset 4
Return Row Number of PREVIOUS Numeric Consecutive Duplicate in Column 3
Dynamic Reference Cell in Offset Formula 3
Load Userform Control Values from Worksheet 2
Offset formula 2

Top