Any suggestion?

[EpsilonRho]

I'm try to solve this problem. I have a column with 1000 numbers; from this
array I want to generate an other array with 1000-K elements that is the
result of the ratio between every element N and N+K, (for example if K=8
....B1=A1/A9, B2=A2/A10, B3=A3/A11, etc.). Now, is it possible to use the
content of a single cell where K is stored, to change the "distance" between
the cell ratios? For example if K=20 then B1=A1/A21, B2=A2/A22, B3=A3/A23.
Thank you very much.
Gene

 

[Sandy Mann]

With K in C1 use:

=A1/INDIRECT("A"&$C$1)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Dana DeLouis]

Another option:

=A1/OFFSET(A1,k,0)

 

[Dave Peterson]

Another:

=A1/index(A:A,k)

I'm try to solve this problem. I have a column with 1000 numbers; from this
array I want to generate an other array with 1000-K elements that is the
result of the ratio between every element N and N+K, (for example if K=8
...B1=A1/A9, B2=A2/A10, B3=A3/A11, etc.). Now, is it possible to use the
content of a single cell where K is stored, to change the "distance" between
the cell ratios? For example if K=20 then B1=A1/A21, B2=A2/A22, B3=A3/A23.
Thank you very much.
Gene

 

[Sandy Mann]

Another option:

If you meant another option to mine then no, not another, mine plain doesn't
work!

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[EpsilonRho]

Thank you very much for the leads!

Gene