Cells dont take values from its parent in a column

[daeiron]

I have the following file:

web.xlsx

For the Tasknr column, i want every row to display the tasknr of its parent so to say. Like in the image below:
Naamloos.png

So every line needs some kind of formula to find out what its 'parent' searchtask is and stop at the next searchtask nr..

Thanks.

[Sindhus]

Hi, For the image attached by you, i understood that whereever, searchtask appears in C column, the no. of tasknr should increase by 1. If my understanding is correct, you can use this formula from A3.

Please Login or Register  to view this content.

Regards,
Sindhu

[daeiron]

Thanks for your answer, but i think you misunderstood.

For: /Searchtask_01a.htm for example. It should take the 1 out of it, and apply it too all its children, till it hits an other /Searchtask_02a.htm, then it should change tasknr to 2 and apply that to its children till it finds /Searchtask_03a etc..

[Sindhus]

You mean to say the searchtasks may not be in the sorted order - 1,2,3,...? Then you can use this formula

Please Login or Register  to view this content.

[daeiron]

It works half, at the lines with searchtask its correct. But when i 'drag' down the formula to copy it to below cells. the cells withou searchtask in it display 1.. Where it should be 2 or 3 for example.

Could you post your xls ?

[daeiron]

I figured it out, had to change the last K2 to K1.

Thanks !!!

[jeffreybrown]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save