So, I have a list exported from a system containing unique employee ids (children). Each of these rows has the employee’s manager unique id (parent). One of the employees is the CEO and is to be considered level = 1
I would like a way to calculate per employee what level they are on in the organization. Is this possible in an effective way?
Have tried a solution I found before based on MATCH and INDEX, but it is cumbersome and seems to consume enormous resources to calculate and recalculated all the time.
<tbody>
</tbody>
I would like a way to calculate per employee what level they are on in the organization. Is this possible in an effective way?
Have tried a solution I found before based on MATCH and INDEX, but it is cumbersome and seems to consume enormous resources to calculate and recalculated all the time.
Unique child id | Unique parent id | level |
1 | 88 | ? |
2 | 99 | ? |
3 | 44 | ? |
4 | 55 | ? |
<tbody>
</tbody>