Autofill Question

[James8309]

Hi everyone,

I am having alot of difficulties trying to solve this problem.

Basically I am coding something in column A like this;

1. 11XXX (X being any number from 0 to 9 i.e.11001 till 11999)

2. X11XX (X being any number from 0 to 9 ) => this part I have a
problem. How do I fill in every possible combination that has 1 in 2nd
and 3rd spot? e.g. 311411, 211423 .. etc etc

Please help (T_T)


thank you for your help in advance

regards,


James

 

[David Biddulph]

1. =11000+ROW()
2. =INT((ROW()-1)/100)*10000+1100+MOD(ROW()-1,100)