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

--
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

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

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