This function produces a Work Breakdown Schedule (WBS)-like numbering system such as:
The function can start in any cell, and the first occurrence of the function is automatically assigned the value "1." Subsequent occurrences of the function in the same column will increment the counter or level depending on the indent level of the cell immediately to the right. No indent is N, indent 1 is N.N, Indent 2 is N.N.N, etc. You can have as many indents as needed. Just copy the formula down for as many tasks as you have and indent the tasks accordingly.
I could probably do a bit more cleanup of the code, but I'm lazy.
Please Login or Register to view this content.