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

[gotzoom]

I need to generate a sequential number list, but I need it to skip every
13th number.

 

[daddylonglegs]

are you starting from 1?

try putting 1 in A1 then in A2

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

and autofill down

 

[gotzoom]

My first list I am starting at 2343.

 

[gotzoom]

Ah-ha, I got it

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