Problem: In an Excel spreadsheet, I want to do outline-numbering, sometimes called “work-breakdown structure” (WBS) numbering, without resorting to macros. I would like to automatically form this type of numbering:
Solution:
If you want to solve this problem and you don’t want to use macros, then you will need to devote a bit of spreadsheet real estate (extra columns) and use some fairly tedious-looking (but simple) formulas.