Creating a WBS numbering system

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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 :
 
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
 
Back
Top