I have a spreadsheet with Column 2 containing tasks for a project. In column one, I would like to have an autonumber feature, (1,2,3,3.1,3.2,3.3,4.11,4.12, etc) which does the following:
1. Determine the level of indent on the cell adjacent right (column 2)
2. Increment based upon the cell above or if indent is "out-dented" incement from last indent of same level
Does this make sense? I am not sure if this is easy or massively difficult. Help me understand and I will go away if this is too hard.
A sample with a column 2 indents is attached.