Auto Numbering

[jharkins]

Can any one help me with this? I am trying to number a cost tabl
sequencially from A.1.1, A1.1.2 and so on. Can you do this in Excel
And can you make to where if you insert a row in between the rows tha
are already numbered that it changes everything automatically? Pleas
Help!!

 

[Guest]

Using Excel 2000, I entered A.1.1 in a cell. Then I used my mouse and
dragged the bottom right corner of the cell down and the list grew
sequentially A.1.1, A.1.2, A.1.3, etc. I did not have much success for Excel
populating inserted rows with sequentially correct data.

 

[HS Hartkamp]

I'd create a couple of columns that each give a part of the numbering, and
get their value depending on the cell above.

Example: A.1.1, A.1.2, etc.

Columns A:C contain switches to start a new number. Columns D:F contain the
partial numbers. Column G concatenates D:F
After that, from column H, you'd have your list.

First row (D1:F1) enter starting values (A, 1 and 1)
Second row: [D2] =IF(A2=1;CHAR(ASCII(B1)+1);B1)
[E2] = IF(B2=1;E1+1;E1)
[F2] = IF(C2=1;F1+1;F1)
[G2] = D2 & "." & E2 & "." & F2
Third row and further, copy second row.

Make sure the print range is set so that it does not include the first 6
columns.
You can hide columns D - E - F, but for the numbering to update after you
insert rows, you must copy the formulas.
If your list contains some bits of information to see when you want a new
(sub-)number, you can use those instead of columns A-B-C.

Bas Hartkamp.