Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for every 13 cells
I need to find a formula for designating a base cell and every 13 cells after
it. For example, by first cell would be B3 so i need the next cell down to be B16 (B3 plus 13), and the next to be B29 (B16 plus 13). So logically, the formula would be the previous cell plus 13 cells down to get the cell number. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for every 13 cells
Perhaps you mean this
Placed in any start cell, say, in C3: =OFFSET($B$3,ROWS($1:1)*13-13,) Copy C3 down as far as required C3 will return the contents of B3, C4 returns the contents of B16 (13 cells down), C5 returns B29's contents, and so on .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "BWSmith" wrote: I need to find a formula for designating a base cell and every 13 cells after it. For example, by first cell would be B3 so i need the next cell down to be B16 (B3 plus 13), and the next to be B29 (B16 plus 13). So logically, the formula would be the previous cell plus 13 cells down to get the cell number. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for every 13 cells
=OFFSET(B$3,13*(ROW()-ROW(C$3)),0) and copy down. I've assumed that your
first formula is in C3, but if not you'll need to change the C$3 to wherever you're starting from. -- David Biddulph "BWSmith" wrote in message ... I need to find a formula for designating a base cell and every 13 cells after it. For example, by first cell would be B3 so i need the next cell down to be B16 (B3 plus 13), and the next to be B29 (B16 plus 13). So logically, the formula would be the previous cell plus 13 cells down to get the cell number. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for every 13 cells
Worked perfect! Thanks!
"Max" wrote: Perhaps you mean this Placed in any start cell, say, in C3: =OFFSET($B$3,ROWS($1:1)*13-13,) Copy C3 down as far as required C3 will return the contents of B3, C4 returns the contents of B16 (13 cells down), C5 returns B29's contents, and so on .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "BWSmith" wrote: I need to find a formula for designating a base cell and every 13 cells after it. For example, by first cell would be B3 so i need the next cell down to be B16 (B3 plus 13), and the next to be B29 (B16 plus 13). So logically, the formula would be the previous cell plus 13 cells down to get the cell number. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for every 13 cells
Good to hear that.
Thanks for feeding back. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "BWSmith" wrote in message ... Worked perfect! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning values to other cells from one cells formula | Excel Discussion (Misc queries) | |||
Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
Formula Help: Add cells with certain text + cells that are blank | Excel Worksheet Functions | |||
Need formula that will sum cells in a column bases on criteria in other cells. | Excel Worksheet Functions | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions |