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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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))
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Validation of UK VAT Number 20
Need to Calculate only part of a formula in Excel 2003 2
Modifying a complex date formual to count months 4
"IF" Function limited to 7 in a formula.... need 14 2
Position of first number in array greater than a given number 4
Convert data from multiple columns/rows into one column - help! 3
Numbering years and months 4

Back
Top