| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Down reference of even number rows
I have Excel 2002, I need to reference only even number row
coordinates, and I would like to do it with a fill down: =B4 =B6 =B8 =B10 ... ... But if I select the first two cells and do a fill down, it duplicates the coordinates? =B4 =B6 =B6 =B8 =B8 =B10 =B10 HELP! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill Down reference of even number rows
Put this in the start cell (where you want: =B4)
=INDIRECT("B"&ROWS($1:1)*2+2) Copy down as far as required -- Max Singapore http://savefile.com/projects/236895 Downloads:18,000 Files:359 Subscribers:56 xdemechanik --- "jyorraku" wrote in message ... I have Excel 2002, I need to reference only even number row coordinates, and I would like to do it with a fill down: =B4 =B6 =B8 =B10 .. .. But if I select the first two cells and do a fill down, it duplicates the coordinates? =B4 =B6 =B6 =B8 =B8 =B10 =B10 HELP! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill Down reference of even number rows
=OFFSET($B$4,(ROW(B4)-4)*2,0)
"jyorraku" wrote: I have Excel 2002, I need to reference only even number row coordinates, and I would like to do it with a fill down: =B4 =B6 =B8 =B10 ... ... But if I select the first two cells and do a fill down, it duplicates the coordinates? =B4 =B6 =B6 =B8 =B8 =B10 =B10 HELP! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill Down reference of even number rows
This formula references cell B4
and contains no volatile functions (which re-calc whenever any other cell re-calcs and can make a workbook sluggish): A1: =INDEX(B:B,ROWS($1:1)*2+2) Copy that formula into A2 and down as far as you need to reference B6, B8....etc Is that something you can work with? Regards, Ron Coderre Microsoft MVP (Excel) "jyorraku" wrote in message ... I have Excel 2002, I need to reference only even number row coordinates, and I would like to do it with a fill down: =B4 =B6 =B8 =B10 .. .. But if I select the first two cells and do a fill down, it duplicates the coordinates? =B4 =B6 =B6 =B8 =B8 =B10 =B10 HELP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-fill a sheet reference | Excel Worksheet Functions | |||
| Auto fill cell reference | Excel Discussion (Misc queries) | |||
| after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
| formula will not fill correctly due to odd number rows | Excel Worksheet Functions | |||
| 3-d reference not adjusting when using Fill Handle to copy down | Excel Worksheet Functions | |||
Linear Mode
