Formula for every 13 cells

[BWSmith]

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.

 

[Max]

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 ..

 

[David Biddulph]

=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.

 

[BWSmith]

Worked perfect! Thanks!

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]

Good to hear that.
Thanks for feeding back.