Referencing every 5th cell in another sheet

[Jan.Thorstensen]

I have one sheet (Sheet1) that contains data. Everey 5th row
in this sheet I want to put a referce to in sheet2.

E.g.

Sheet2.A1 = Sheet1! A1
Sheet2!A2 = Sheet1! A6
Sheet2!A3 = Sheet1! A11
Sheet2!A4 = Sheet1! A16

and so on...

Is there a way I can use Autofill in Sheet2 and return every 5th cell
from the other sheet, sheet1?

Regards
Jan

 

[xlbo]

No easy way unfortunately but this formula should do the trick:

=INDIRECT("Sheet1!A"&(ROW()*5)-4)

 

[MartinW]

Hi Jan,

One way, post this in Sheet2 cell A1
=INDEX(Sheet1!A:A,ROW()*5-4)
Grab the fill handle and drag down as far as is needed

HTH
Martin

 

[Jan T.]

No easy way unfortunately but this formula should do the trick:

=INDIRECT("Sheet1!A"&(ROW()*5)-4)
--
Rgds, Geoff








- Vis sitert tekst -

Sweet! Very Nice.

Thanks a lot!

Regards
Jan.

 

[Teethless mama]

Try this:

=OFFSET(Sheet1!$A$1,(ROWS($1:1)-1)*5,0)