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