Hi..

I have translated it into Norwegian, and typed your suggestions, but....

First of all I've got an error so I changed the formula to this:

=OFFSET(A$1;2;;;)

According to Excel Help the first parameter is the cell of origin. The
second is the offset size. The third, fourth and fifth I can forget this
time.

Anyhow. After typing the formula and got the right value shown in the first
cell, I copied downwards and the values came out wrong.
The A$1 changed to A$2, and the value shown was the value of the cell
situated two cells below A2. That was not what I wanted. This led to a list
where every number in the column was shown, not every second.
If I locked the entire first parameter with the cell of origin, I got the
same value as in the in the first in all the cells below the first.
I wanted to be able to pick out every second or 25.th, for that matter,
value in a column of values, and show them in a column of adjacent cells.




--

regards
Zadig Galbaras
A Perturbed Norwegian Agnostic
-


"Biff" skrev i melding
...
Hi!

In D1 enter this formula and copy down as needed:

=OFFSET(A$1,(ROW()-1)*25,,)

Biff

-----Original Message-----
Hi.

My spreadsheet has a repetitive calculation for each
25.th row.
In another place I want to list up each of these values,
but then in each
and every row downwards.

That is;
A1 = 25
A26 = 26
A51 = 23

Now I want to copy these values to lets say to D1 like
this
D1 = 25 - Linked to A1
D2 = 26 - Linked to A26
D3 = 23 - Linked to A51

Is there a trick in the formula in D2 to automatically
jump 25 rows from the
row mentioned in D1, so it shows the value in A26,
without me having to sit
here day and night in a week to do the tedious copy and
link jockey routine?


--

regards
Zadig Galbaras
A Perturbed Norwegian Agnostic
-


.