+ Reply to Thread
Results 1 to 13 of 13

Extracting Predecessor as a list

  1. #1
    Registered User
    Join Date
    03-16-2022
    Location
    USA
    MS-Off Ver
    2022
    Posts
    11

    Extracting Predecessor as a list

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

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,860

    Re: Extracting Predecessor as a list

    Hi arpitprakash,

    Looks like you want to use TextJoin() and hold the top row with a $. See the attached.
    TextJoin from the top.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    03-16-2022
    Location
    USA
    MS-Off Ver
    2022
    Posts
    11

    Re: Extracting Predecessor as a list

    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'.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,860

    Re: Extracting Predecessor as a list

    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.

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,261

    Re: Extracting Predecessor as a list

    Please Login or Register  to view this content.
    in D4

    =Pre_list(C4)

    Copy down
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  6. #6
    Registered User
    Join Date
    03-16-2022
    Location
    USA
    MS-Off Ver
    2022
    Posts
    11

    Re: Extracting Predecessor as a list

    Thanks, JohnTopley, worked like charm!!

  7. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,261

    Re: Extracting Predecessor as a list

    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.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    03-16-2022
    Location
    USA
    MS-Off Ver
    2022
    Posts
    11

    Re: Extracting Predecessor as a list

    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?
    Attached Files Attached Files

  9. #9
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,261

    Re: Extracting Predecessor as a list

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

  10. #10
    Registered User
    Join Date
    03-16-2022
    Location
    USA
    MS-Off Ver
    2022
    Posts
    11

    Re: Extracting Predecessor as a list

    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.

  11. #11
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,261

    Re: Extracting Predecessor as a list

    As per columns H:I in attached ??
    Attached Files Attached Files

  12. #12
    Registered User
    Join Date
    03-16-2022
    Location
    USA
    MS-Off Ver
    2022
    Posts
    11

    Re: Extracting Predecessor as a list

    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.

  13. #13
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,261

    Re: Extracting Predecessor as a list

    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)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Add 1 to date if Predecessor
    By WaveWalker116 in forum Excel General
    Replies: 2
    Last Post: 07-30-2020, 11:48 AM
  2. Random Formula - Larger than predecessor
    By Xcelrion in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-26-2019, 05:03 AM
  3. Excel Project Plan with Multiple Predecessor Relationships
    By PWATL in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-02-2017, 03:11 PM
  4. [SOLVED] Extracting Bottom 3 Values From a List Selected from a Drop-Down List
    By AliGW in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-03-2017, 01:21 AM
  5. Calculate date on predecessor
    By Rajnishbhatt in forum Excel General
    Replies: 2
    Last Post: 08-14-2014, 02:34 PM
  6. [SOLVED] Extracting summary list of larger list showing only items that have quantities
    By BenjaminRCP in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-14-2014, 01:01 PM
  7. Format rows based on predecessor value in a column
    By hoss88 in forum Excel General
    Replies: 6
    Last Post: 03-20-2013, 05:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1