| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I auto fill zip code column when city is typed | Excel Worksheet Functions | |||
| Auto fill Column based on data in other columns | New Users to Excel | |||
| Auto Fill, Every other column | Excel Discussion (Misc queries) | |||
| Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions | |||
| How do I get auto fill to do decending numbers in a column? | Excel Discussion (Misc queries) | |||
Linear Mode
