Auto Numbering

[Jeff1981]

Part No Desc Model
000001 My Part1 My Product
000002 My Part2 My product
000003 My Part3 My Product
Auto My Part4 My Product

I would like to know if excel is capable of auto numbering the next sequencial number in the part number column above. In addition, I would like to know if the sequencial number can be added automatically to each row when information is added to the description column.

thank you
jeff

 

[VoG]

Select A1:A3 and drag down.

 

[Jeff1981]

so auto-numbering is easy if I want a long list of part numbers with unassigned descriptions. any takers on whether I can auto add a single row / next sequencial number when the description field is populated?

thank you

 

[Marcelo Branco]

Hi Jeff

Maybe this (assuming headers in A1:C1)

Formula in A2
=IF(B2<>"",SUM(A1)+1,"")
copy down

HTH

M.

 

[West Man]

In the event that the data gets sorted so that the sequence numbers are no longer in order try in A5: =IF(B5<>"",MAX(A$2:A4)+1