Creating a WBS numbering system
 

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

Creating a WBS numbering system
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"M Houghton" <M schrieb im
Newsbeitrag ...
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

Creating a WBS numbering system
 

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 :

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

Creating a WBS numbering system
 

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

HTH,
Gary Brown


"M Houghton" wrote:

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