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