Creating a WBS numbering system

[Guest]

Looking for a way to number a work breakdown structure in excel.
This is the desired output:
1.2.3 Labor
1.2.3 Other
1.2.3 Cont
1.2.4 Labor
1.2.4 Other
1.2.4 Cont

When the text equals "Cont" have the cell below increase by the lowest element
Anybody have any ideas??? Thanks for your time and attention - Mark

 

[Frank Kabel]

Hi
IMHO don't use Excel for this. Excel just has no function built.in to
do this. Project/Word is IMHO better suited for such tasks

 

[keepITcool]

Mark, try a formula like:

in A2 =OFFSET(A2,-1,0)+N(OFFSET(A2,-1,1)="Cont")
Custom Numberformat: "0\.0\.0"

Using the offset function ensures formula integrity when
lines are inserted or deleted.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


M Houghton wrote :

 

[Guest]

Assuming the 1.2.3...... is Col A and 'Labor'.... is Col B
In A7
=LEFT(A6,FIND("~",SUBSTITUTE(A6,".","~",2)))&(VALUE(RIGHT(A6,LEN(A6)-FIND("~",SUBSTITUTE(A6,".","~",2))))+1)

HTH,
Gary Brown