Fill cells increment row number i fomula

  • Thread starter Thread starter Øyvind Granberg
  • Start date 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

(e-mail address removed)
www.tresfjording.com
 
One way to retreive the values (not create the formula):

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