# Finding successors in a schedule if predecessors are known

#### Innoguide

##### Board Regular
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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Can you explain exactly how you get each of these results please ?

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!

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 ?

Replies
0
Views
135
Replies
19
Views
648
Replies
2
Views
116
Replies
7
Views
165
Replies
22
Views
242

1,202,908
Messages
6,052,485
Members
444,587
Latest member
ezza59

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

### Which adblocker are you using?

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

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