How to auto fill with fifth cell in a column?
 

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

How to auto fill with fifth cell in a column?
 

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:

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

How to auto fill with fifth cell in a column?
 

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)
--
David Biddulph

"Asghar Gill" wrote in message
...
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.
--
GillAA

How to auto fill with fifth cell in a column?
 

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

"Asghar Gill" wrote:

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

How to auto fill with fifth cell in a column?
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Asghar Gill" wrote:
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.
--
GillAA