I have a list of work weeks in a column and next to it a list of zero's and ones. Zeros indicate that week is not going to be worked and 1's indicate that week will be worked. in the Chassis LL parts column there is a number 6 and in the Chassis Start column a number 1 . I want to add these two numbers, then match the build week (w1446) and count backwards until I count the 7 work weeks to find the start week to complete the work (in this case it would be W1438 because w1445 is downweek (0)to display in the "Chassis Start"column
<tbody>
</tbody>
| w1433 | 1 | GSO | Build Week | Chassis Design | Chassis LLParts | Chassis Start | |||
| w1434 | 1 | w1446 | 6 | 1 | |||||
| w1435 | 1 | ||||||||
| w1436 | 1 | ||||||||
| w1437 | 1 | ||||||||
| w1438 | 1 | ||||||||
| w1439 | 1 | ||||||||
| w1440 | 1 | ||||||||
| w1441 | 1 | ||||||||
| w1442 | 1 | ||||||||
| w1443 | 1 | ||||||||
| w1444 | 1 | ||||||||
| w1445 | 0 | ||||||||
| w1446 | 1 | ||||||||
| w1447 | 1 | ||||||||
| w1448 | 1 | ||||||||
| w1449 | 1 | ||||||||
| w1450 | 1 | ||||||||
| w1451 | 1 | ||||||||
| w1452 | 0 |
<tbody>
</tbody>
