Distribute a table (2)

[Mamdouh Elfors]

Hi
I have another request
Can the numbers be distributed in the first table from the beginning of the month to a specified number of months?
Attachment file for clarification
Thanks

 

[Luiz Carlos]

Hello!
Check the spreadsheet and make a comeback.

 

[Mamdouh Elfors]

This is OK It's simpler
Thanks Luiz

 

[p45cal]

in cell G2:
=IF(AND((MATCH(G$2,$C$3:$C$14,0)-$F3)>=0,(MATCH(G$2,$C$3:$C$14,0)-$F3)<8),$D3,0)
copied down and across.

If you want the specified number to be variable, put that number in say cell F2 and change the formula to:
=IF(AND((MATCH(G$2,$C$3:$C$14,0)-$F3)>=0,(MATCH(G$2,$C$3:$C$14,0)-$F3)<$F$2),$D3,0)

 

[Mamdouh Elfors]

Thanks p45cal

 

[Peter Bartholomew]

If you sum the columns of your table you get a particular case of a convolution (math) or spread (finance). An interesting feature is that the input amounts and the distribution can be input either way round and give the same result. The objective of the original work was to calculated the sums without writing out a large helper range such as you need.

ps The spreadsheets are old but I have input your data on a dynamic array version of Excel so there is no guarantee that they will still work on production versions of Excel. I am hoping that they will at least be readable when downloaded even if they do not calculate.