Hi,
I have two columns with Entry no and TRansferred from entry no and would need to calculate a column Expected initial Entry no, that brings the initial entry no if an item has transferred ( it's differnt than zero).
It is easy to bring the value if we have one transfer for example entry 2 but I couldnt find a solution where you have multiple transfers. Eg. entry no 5, the initial entry no is 1.
<tbody>
</tbody>
Any help would be much appreciated.
I have two columns with Entry no and TRansferred from entry no and would need to calculate a column Expected initial Entry no, that brings the initial entry no if an item has transferred ( it's differnt than zero).
It is easy to bring the value if we have one transfer for example entry 2 but I couldnt find a solution where you have multiple transfers. Eg. entry no 5, the initial entry no is 1.
Entry no | Transferred from entry no | Expected result initial entry | Comment how expected should work |
1 | 0 | 1 | Entry no is 1 and it's transferred from 0 then bring Entry no 1 |
2 | 1 | 1 | Entry no 2 is coming from entry no 1, and entry no 1 is transferred from zero than bring 1 |
3 | 0 | 3 | Entry no 3 is transferred from 0 then bring Entry no 3 |
4 | 2 | 1 | Entry no 4 is transferred from 2, and 2 it's transferred from 1, and 1 is transferred from 0, then bring 1 |
5 | 4 | 1 | Entry no 5 is transferred from 4, and 4 it's transferred from 2, 2 is transferred from 1 and 1 is transferred from 0, then bring 1 |
6 | 5 | 1 | Entry no 6 is transferred from 5, and 5 is transferred from 4, 4 is transferred from 2, 2 from 1 and 1 from 0 then 1 |
7 | 0 | 7 | Entry 7 is transferred from 0 then bring Entry no 7 |
8 | 4 | 1 | Entry no 8 is transferred from 4, and 4 it's transferred from 2, 2 is transferred from 1 and 1 is transferred from 0, then bring 1 |
9 | 1 | 1 | Entry no 9 is transferred from 1, 1 is tranferred from zero then bring 1 |
<tbody>
</tbody>
Any help would be much appreciated.