| A | B | C | D | E | F | G | H |
---|
| | | | | | | | |
1st degree dependencies | | | | | | | | |
| | | | | | | | |
Green consumes Red | Car | Dog | House | Computer | Your Mom | Wizard | Cake | |
Car | x | | | | | | | |
Dog | x | x | | | | | | |
House | x | | | | | | | |
Computer | x | | | | | | | |
Your Mom | | | | | | | | |
Wizard | x | | | | | | | |
Cake | | | | | | | | |
| | | | | | | | |
| | | | | | | | |
2nd degree dependencies | | | | | | | | |
| | | | | | | | |
Green consumes Red | Car | Dog | House | Computer | Your Mom | Wizard | Cake | |
Car | | | | x | | | | |
Dog | | | x | | | x | | |
House | | | | | | | | |
Computer | | | | | | | | |
Your Mom | | | | | | | | |
Wizard | | | | | | | | |
Cake | | | | | | | | |
| | | | | | | | |
| | | | | | | | |
3rd degree dependencies | | | | | | | | |
| | | | | | | | |
Green consumes Red | Car | Dog | House | Computer | Your Mom | Wizard | Cake | |
Car | | | | | | | | |
Dog | | | | x | | | | |
House | | | | | | | | |
Computer | | | | | | | | |
Your Mom | | | | | | | | |
Wizard | | | | | | | | |
Cake | | | | | | | | |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="bgcolor: #757171, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #757171, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #757171, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #757171, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #757171, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #757171, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #757171, align: right"][/TD]
[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]17[/TD]
[TD="bgcolor: #757171"][/TD]
[TD="align: center"]18[/TD]
[TD="bgcolor: #757171"][/TD]
[TD="align: center"]19[/TD]
[TD="bgcolor: #757171"][/TD]
[TD="align: center"]20[/TD]
[TD="bgcolor: #757171"][/TD]
[TD="align: center"]21[/TD]
[TD="bgcolor: #757171"][/TD]
[TD="align: center"]22[/TD]
[TD="bgcolor: #757171"][/TD]
[TD="align: center"]23[/TD]
[TD="bgcolor: #757171"][/TD]
[TD="align: center"]24[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]25[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]26[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]27[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]28[/TD]
[TD="align: center"]29[/TD]
[TD="bgcolor: #757171"][/TD]
[TD="align: center"]30[/TD]
[TD="bgcolor: #757171"][/TD]
[TD="align: center"]31[/TD]
[TD="bgcolor: #757171"][/TD]
[TD="align: center"]32[/TD]
[TD="bgcolor: #757171"][/TD]
[TD="align: center"]33[/TD]
[TD="bgcolor: #757171"][/TD]
[TD="align: center"]34[/TD]
[TD="bgcolor: #757171"][/TD]
[TD="align: center"]35[/TD]
[TD="bgcolor: #757171"][/TD]
</tbody>
If entered correctly, Excel will surround with curly braces {}.
Put the formula in B17, confirm with Control+Shift+Enter. Then copy to B17:H23 and B29:H35.
It does rely on the gap between tables being the same. If you change the ranges, you may need to adjust the formula within each table to match the proper ranges.