Fill cells increment row number i fomula

  • Thread starter Øyvind Granberg
  • Start date
Ø

Øyvind Granberg

Hi..

I have to link two cells, where the original cells is 25 rows apart.

How can I in the recieving spreadsheet copy down with 25 rows increment in
formula.

If A1: =sheet1!$KE$1
and A2: =sheet1!$KE$26

I want to fill this down in such way that A3: =sheet1!$KE$51 and A4:
=sheet1!$KE$76 and so on.
So you see, in sheet1 the data is 25 rows apart, while in sheet2 the value
should come in every cell in the row.

I'm not talking about the fill function which seems to refer to the value of
the cell only, and not the formula.

Is this possible?


--

Kind regards
Øyvind Granberg

[email protected]
www.tresfjording.com
 
D

Dave Peterson

One way to retreive the values (not create the formula):

=INDEX(Sheet1!KE:KE,(ROW()-1)*25+1)
 
Top