Extracting Predecessor as a list

[arpitprakash]

Is there a way to extract all Predecessor information per Task as a comma-separated list?

[MarvinP]

Hi arpitprakash,

Looks like you want to use TextJoin() and hold the top row with a $. See the attached.
TextJoin from the top.xlsx

[arpitprakash]

Hi MarvinP,
Unfortunately, this won't work. I need a list of all Predecessors starting from the select task, which could be randomly defined. Eg. as per Column C, the Predecessor of Task 7 has been set as Task 3, whose Predecessor is Task 2. The result that I need to compute, which has been provided as an example in Column D, is '7,3,2'.

[MarvinP]

Hi arpitprakash,

Sorry, I didn't see the numbers didn't follow some order. Could you give us more information about what the correct answer would be and why? Is this a scheduling problem where one task has to be done before the other? Is this what you are looking for? What are you given and be more specific about the order of the tasks.

[JohnTopley]

Please Login or Register  to view this content.

in D4

=Pre_list(C4)

Copy down

[arpitprakash]

Thanks, JohnTopley, worked like charm!!

[JohnTopley]

The named range PIDList is fixed so I added 0 (zero) into c2:c3 (hidden with Font white) and defined named range PIDList as a dynamic range:


=OFFSET(Sheet1!$C$1,,,COUNTA(Sheet1!$C$1:$C$1000),1)

Minor change to code:

Please Login or Register  to view this content.

[arpitprakash]

VBA is beyond me as of now, but really appreciate this!

I do have another small request on top of this. How can write the Task ID for select Task on a new column, against its predecessors? Can I select a Task ID as an input, which populates the relevant rows?

[JohnTopley]

Where do you want results so for E3 result is D10 ?

[arpitprakash]

No, I want the results in Column E based on Column D. Example, if I chose the input as A10, based on the results in D10, I want on all the rows in Column E to be populated. Column F is another example where I am my input is A8.

[JohnTopley]

As per columns H:I in attached ??

[arpitprakash]

I provided Columns E and F as the end-result examples, based on Column D results. So for the final result should be > Column H, replace all (8,7,3,2) with 9, from Column A, and Column I replace (3,2) with 7.

Sorry for so many questions, but I am very limited in my Excel knowledge Really appreciate you taking the time here.

[JohnTopley]

Sorry but I completely lost as do not see how to get to column E (9) when there no reference to the "Driving IDs" (column D)