View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BWSmith BWSmith is offline
external usenet poster
 
Posts: 2
Default 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.