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

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 Removed)
Replace @mailinator.com with @tiscali.co.uk


"EpsilonRho" <(E-Mail Removed)> wrote in message
news:FnGCi.1267$(E-Mail Removed)...
> 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
>
>
>

Another option:

=A1/OFFSET(A1,k,0)

--
HTH :>)
Dana DeLouis


"EpsilonRho" <(E-Mail Removed)> wrote in message
news:FnGCi.1267$(E-Mail Removed)...
> 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
>
>

Another:

=A1/index(A:A,k)



EpsilonRho wrote:
>
> 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

--

Dave Peterson

"Dana DeLouis" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 Removed)
Replace @mailinator.com with @tiscali.co.uk

Thank you very much for the leads!

Gene