How to auto fill with fifth cell in a column?

[Guest]

I can't find a formula where I can copy each fifth cell value to another
column. I wanted vales from G2, g7, g12 ...........g512 in Y column. Any help
will be greatly appreciated.

 

[Guest]

in Y2 put this: =G2
in Y7 put this: =G7
now select Y3:Y7
grab the fill handle and pull down as long u like


"Asghar Gill" skrev:

 

[David Biddulph]

If you want the values to appear every 5 rows in Y, then use
=IF(MOD(G1,5)=2,G1,"")

If you want consecutive rows in Y, then
=OFFSET(G$2,5*(ROW()-1),0)

 

[Guest]

In Y2: =G2
In Y3: =OFFSET($G$2,ROWS($1:1)*5,0)
copy down

 

[Guest]

Another thought ..
In the starting cell in col Y, say in Y2:
=OFFSET($G$2,ROW(A1)*5-5,)
Copy Y2 down as far as required