F

#### Frank Van Eygen

In columns B, C and D are numbers

In cell E1 a SQRT-calculation involving cells B1 to D2:

=SQRT(POWER((B1-B2);2)+POWER((C1-C2);2)+POWER((D1-D2);2))

In cell E1 a SQRT-calculation involving cells B2 to D3:

=SQRT(POWER((B2-B3);2)+POWER((C2-C3);2)+POWER((D2-D3);2))

and so on, untill E10 (where cell A10 named "End_1" is)

I would like to autofill column E using the named cells as a starting point

with OFFSET or an other function.

Until now I tride in cell E1:

=SQRT(POWER(((OFFSET(Start_1;0;1))-(OFFSET(Start_1;1;1)));2)+POWER(((OFFSET(Start_1;0;2))-(OFFSET(Start_1;1;2)));2)+POWER(((OFFSET(Start_1;0;3))-(OFFSET(Start_1;1;3)));2))

In cell E2:

=SQRT(POWER(((OFFSET(Start_1;1;1))-(OFFSET(Start_1;2;1)));2)+POWER(((OFFSET(Start_1;1;2))-(OFFSET(Start_1;2;2)));2)+POWER(((OFFSET(Start_1;1;3))-(OFFSET(Start_1;2;3)));2))

My question is how can I use the autofill function in column E so that I

don't have to change the rows and cols arguments manually in each OFFSET

function in the formula?

Is there a way to use a row-reference relative to a named cell in an OFFSET

function?