# Distribute a Period over Multiple Columns

#### Mathijs

##### New Member
Hi everyone,

I'm struggling to distribute the Duration in column B over the correct period with a formula, in order to translate the table above indicating when a new project starts into the table below which sums up the current running projects.

For example, Project 1 has a duration of 2 months. As indicated in the table above, the project starts in January 2019. Is there a formula that distributes these two months to the according periods, starting with January?

The Running Projects table below should be the result. Does anyone have suggestions? Looking forward to think along.

Best,

Mathijs
# new projects started
 Project type Duration (months) jan-19 feb-19 mar-19 apr-19 may-19 jun-19 Project 1 2 1 0 0 1 0 0 Project 2 4 0 1 0 0 1 0

<tbody>
</tbody>

# running projects cumulative
 jan-19 feb-19 mar-19 apr-19 may-19 jun-19 Project 1 1 1 0 1 1 0 Project 2 0 1 1 1 2 1

<tbody>
</tbody>

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

Replies
20
Views
621
Replies
0
Views
630
Replies
1
Views
402
Replies
5
Views
60
Replies
5
Views
112

1,203,506
Messages
6,055,796
Members
444,825
Latest member
aggerdanny

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