I have a project network spreadsheet shown below and in column BT I need to identify each non-critical path task (value in column BS is "N") that has a critical path task (value in column BS is "Y") as one of it's immediate predecessors. Predecessor tasks are listed with commas separating them in column G. They are also separated out into columns H through Q for another function in the spreadsheet if that helps.
Note: Task ID's can be numeric or text
Thanks in advance for any help
Note: Task ID's can be numeric or text
Thanks in advance for any help
Excel Workbook | ||||||
---|---|---|---|---|---|---|
B | G | BS | BT | |||
11 | Task ID | Preceding Tasks * * * * * *(comma seperated) | CP? | * | ||
12 | Start | * | Y | * | ||
13 | a | Start | Y | * | ||
14 | b | a | Y | * | ||
15 | d | b | Y | * | ||
16 | e | b | N | X | ||
17 | c | b | N | X | ||
18 | f | c | N | * | ||
19 | g | * | N | * | ||
20 | h | * | N | * | ||
21 | i | h | N | * | ||
22 | j | e,d,i,g,f | Y | * | ||
23 | k | j | Y | * | ||
24 | Finish | k | * | * | ||
25 | 0 | * | * | * | ||
Sheet |
Last edited: