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

J

Jeff

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
 
D

Duke Carey

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))
 
J

Jeff

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
 
Top