I have a range where I need to derive the level/depth in the hierarchy for each cell where some cells are comma seperated , for example:
<tbody>
</tbody>
In this example range, the level of T0, T5 is 1. The level of T1,T3,T4 is 2. The level of T2 is 3, The level of T8 is 4, I need an output like this
<tbody>
</tbody>
Can anyone please provide direction in Excel how to achieve this
Task | SubTask | ParentTask |
T1 | T2 | T0 |
T5 | T3,T4 | |
T8 | T2 |
<tbody>
</tbody>
In this example range, the level of T0, T5 is 1. The level of T1,T3,T4 is 2. The level of T2 is 3, The level of T8 is 4, I need an output like this
Task | Level |
T0 | 1 |
T5 | 1 |
T1 | 2 |
T3 | 2 |
T4 | 2 |
T2 | 3 |
T8 | 4 |
<tbody>
</tbody>
Can anyone please provide direction in Excel how to achieve this