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:
Capture.PNG
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
Can anyone please provide direction in Excel how to achieve this
Bookmarks