Finding successors in a schedule if predecessors are known

Innoguide

Board Regular
Joined
Sep 13, 2011
Messages
159
I have a table of data as shown below. Column A is the label for the task (could be letters or numbers). The tasks are not necessarily listed in any order. Columns B-E are used to identify the tasks that are immediate predecessors of the task in that row (limited to 4 in this example). Columns F-J need to identify the tasks which are successors. The number of columns would be fixed, but equal to the number of tasks less 1 – since all of the tasks except the last. Or maybe it could be done with the number of tasks less 2, since atask cannot follow itself. Hmmm… in any event, here’s the table:

___A__B__C__D__E__F__G__H__I__J
1__a
2__b__a
3__c__a
4__d__b__ c
5__e__d
6__ f__e


The answers in this case (one label per column) would be

Row 1: b,c
Row 2: d
Row 3: d
Row 4: e
Row 5: f

Any suggestions for what the formulas in F1 through J5 would need to be to return the labels of the successors?

Thanks for any help!
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Sure Gerald - the columns B-E show the column labels that correspond to tasks that depend on the task in that row being completed. This is entered by the user.

Any task that depends on another task is a successor of that task. The results shown are simply by inspection. I am looking for a method to identify all of the successors of the task in any row and then to place labels corresponding to those rows successively in rows.F-J.

Thanks!
 
Upvote 0
Yes I think I understand the general idea, but when I try to match the individual entries I'm having difficulty working them all out.
So, can you explain each one please ?
 
Upvote 0

Forum statistics

Threads
1,226,453
Messages
6,191,137
Members
453,642
Latest member
jefals

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top