How to auto fill with fifth cell in a column?

A

Asghar Gill

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.
 
E

excelent

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:
 
D

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)
 
M

Max

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
 
Top