how to add auto complete number in excel

[M.K]

Hi All,

Please i need your help to do the auto number in excel as following:

if I write for example in Cell 5 and second cell 10 the result will be
automatic in cell A1:E1 as following

5
6
7
8
9
10

and if I write in cell for example 550 and second cell 556 the result will be

550
551
552
553
554
555
556

 

[Gord Dibben]

Automatic would require VBA.

Manually select C5:C10 after the two numbers are entered.

Edit>Fill>Series>Linear>Step Value of 1 and OK


Gord Dibben MS Excel MVP

 

[Max]

Another angle, and a formulas play ...

Assume the starting & ending numbers for the serializing will be input in
A2:B2
eg A2 contains: 5, B2 contains: 10

You could place this in A1
=IF(OR(COUNT($A$2:$B$2)<2,$A$2>$B$2),"",IF(COLUMNS($A:A)>($B$2-$A$2)+1,"",$A$2+COLUMNS($A:A)-1))
Copy A1 right across to IV1. This will achieve the exact automatic
serializing effect that you seek.

P/s: I took you seriously when you said: ... in A1:E1,
implying that you wanted it serialized horizontally

Success? Punch it here, click the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[M.K]

Hi Max

Thank you, that what i want but please can i make answer in A1 to A5 not in
A1 to E1

 

[Max]

To auto-serialize vertically down the column ...

Assume the starting & ending numbers
for the serializing will be input in C11
eg C1 contains: 5, D1 contains: 10

Place in any starting cell, say, in A3
=IF(OR(COUNT($C$1:$D$1)<2,$C$1>$D$1),"",IF(ROWS($1:1)>($D$1-$C$1)+1,"",$C$1+ROWS($1:1)-1))
Copy A3 down as far as required to cater for the max expected extent
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik