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