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.

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.

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.

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.

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!