using auto fill, but need to skip every 13th number

  • Thread starter Thread starter gotzoom
  • Start date Start date
G

gotzoom

I need to generate a sequential number list, but I need it to skip every
13th number.
 
are you starting from 1?

try putting 1 in A1 then in A2

=A1+1+(MOD(A1+1,13)=0)

and autofill down
 
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

auto fill help needed 1
Custom Friday The 13th Coffee Table Imprisons Jason Voorhees 0
Count weekdays from NOW() to a future date. 8
Excel Numbering rows by font color, but skipping blanks 1
Skipping weekends during a count 1
Creating independant Arrays of sequential numbers 1
Auto fill not working 2
numbering rows, but skipping blanks 13

Back
Top