View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.