Hi All,
In my data I need to provide start ID and end ID for each manager and its dependent. For a manager Node 0 and its dependent Node 1.1 and Node 1.2, the start ID will be 1 and end ID will be 2 and 3. For manager Node 1 and its dependent Node 1.1 and Node 1.2, the start ID is 2 and end ID is 4 and 5. Could you please help me on the same.
Input file:
Output file:
Regards,
Shikha
Thanks David.
The multi-row formula is not working when my data level increases. For e.g. in the below screen shot for Manager Node 1.1.1 the start id should be "9" however, here it is coming as "5".
Regards,
Shikha
This provides a unique ID for each node, but they aren't the same as yours due to ordering. If you need the exact numbers you've stated you'll need to order them appropriately before numbering.
