need help with an equation in worksheet to populate numbers onto c

Assuming you have no values in column B above B11, this should work

=IF(OR(MOD(ROW(),10)=0,MOD(ROW(),10)>7),"",1+IF(MOD(ROW(),10)=1,B7,B10))

"Jeff" wrote:

> Hi all,
> Please help me on an equation. This is what I am trying to do.
>
> The numbering starts on Cell(B11) with 1, then it goes down vertically
> for 7 numbers (b17), skips 3 cells, then starts back on b21 with 8, runs down
> vertically again to 14 (b27)... skips 3 cells....
> In short, the numbering goes vertically, and it puts consecutive numbers
> on 7 cells, then skips 3, continues on the 10th cell with the next number.
>
> Please help

Duke, thx for the reply, i hv that figured out, too
I just fill in the 1st 7 numbers, then skip the next 3.. on my 11th cell, i
type
=IF(B11<>"",B11+7,"").. it works out just fine

"Duke Carey" wrote:

> Assuming you have no values in column B above B11, this should work
>
> =IF(OR(MOD(ROW(),10)=0,MOD(ROW(),10)>7),"",1+IF(MOD(ROW(),10)=1,B7,B10))
>
> "Jeff" wrote:
>
> > Hi all,
> > Please help me on an equation. This is what I am trying to do.
> >
> > The numbering starts on Cell(B11) with 1, then it goes down vertically
> > for 7 numbers (b17), skips 3 cells, then starts back on b21 with 8, runs down
> > vertically again to 14 (b27)... skips 3 cells....
> > In short, the numbering goes vertically, and it puts consecutive numbers
> > on 7 cells, then skips 3, continues on the 10th cell with the next number.
> >
> > Please help

Assuming you have no values in column B above B11, this should work

=IF(OR(MOD(ROW(),10)=0,MOD(ROW(),10)>7),"",1+IF(MOD(ROW(),10)=1,B7,B10))

"Jeff" wrote:

> Hi all,
> Please help me on an equation. This is what I am trying to do.
>
> The numbering starts on Cell(B11) with 1, then it goes down vertically
> for 7 numbers (b17), skips 3 cells, then starts back on b21 with 8, runs down
> vertically again to 14 (b27)... skips 3 cells....
> In short, the numbering goes vertically, and it puts consecutive numbers
> on 7 cells, then skips 3, continues on the 10th cell with the next number.
>
> Please help

Duke, thx for the reply, i hv that figured out, too
I just fill in the 1st 7 numbers, then skip the next 3.. on my 11th cell, i
type
=IF(B11<>"",B11+7,"").. it works out just fine

"Duke Carey" wrote:

> Assuming you have no values in column B above B11, this should work
>
> =IF(OR(MOD(ROW(),10)=0,MOD(ROW(),10)>7),"",1+IF(MOD(ROW(),10)=1,B7,B10))
>
> "Jeff" wrote:
>
> > Hi all,
> > Please help me on an equation. This is what I am trying to do.
> >
> > The numbering starts on Cell(B11) with 1, then it goes down vertically
> > for 7 numbers (b17), skips 3 cells, then starts back on b21 with 8, runs down
> > vertically again to 14 (b27)... skips 3 cells....
> > In short, the numbering goes vertically, and it puts consecutive numbers
> > on 7 cells, then skips 3, continues on the 10th cell with the next number.
> >
> > Please help

Hi all,
Please help me on an equation. This is what I am trying to do.

The numbering starts on Cell(B11) with 1, then it goes down vertically
for 7 numbers (b17), skips 3 cells, then starts back on b21 with 8, runs down
vertically again to 14 (b27)... skips 3 cells....
In short, the numbering goes vertically, and it puts consecutive numbers
on 7 cells, then skips 3, continues on the 10th cell with the next number.

Please help

Assuming you have no values in column B above B11, this should work

=IF(OR(MOD(ROW(),10)=0,MOD(ROW(),10)>7),"",1+IF(MOD(ROW(),10)=1,B7,B10))

"Jeff" wrote:

> Hi all,
> Please help me on an equation. This is what I am trying to do.
>
> The numbering starts on Cell(B11) with 1, then it goes down vertically
> for 7 numbers (b17), skips 3 cells, then starts back on b21 with 8, runs down
> vertically again to 14 (b27)... skips 3 cells....
> In short, the numbering goes vertically, and it puts consecutive numbers
> on 7 cells, then skips 3, continues on the 10th cell with the next number.
>
> Please help

Duke, thx for the reply, i hv that figured out, too
I just fill in the 1st 7 numbers, then skip the next 3.. on my 11th cell, i
type
=IF(B11<>"",B11+7,"").. it works out just fine

"Duke Carey" wrote:

> Assuming you have no values in column B above B11, this should work
>
> =IF(OR(MOD(ROW(),10)=0,MOD(ROW(),10)>7),"",1+IF(MOD(ROW(),10)=1,B7,B10))
>
> "Jeff" wrote:
>
> > Hi all,
> > Please help me on an equation. This is what I am trying to do.
> >
> > The numbering starts on Cell(B11) with 1, then it goes down vertically
> > for 7 numbers (b17), skips 3 cells, then starts back on b21 with 8, runs down
> > vertically again to 14 (b27)... skips 3 cells....
> > In short, the numbering goes vertically, and it puts consecutive numbers
> > on 7 cells, then skips 3, continues on the 10th cell with the next number.
> >
> > Please help