How to fill empty rows with a formula that decrease in value over time

Question

Hello,

This is a sample from my data table:

DateProfitLoss1/1/2011100000500002/1/2011  3/1/2011  4/1/2011  5/1/2011  6/1/2011  7/1/2011  8/1/2011  9/1/2011  10/1/2011  11/1/2011  12/1/2011  1/1/201290000470002/1/2012  3/1/2012  4/1/2012  5/1/2012  6/1/2012  7/1/2012  8/1/2012  9/1/2012  10/1/2012  11/1/2012  12/1/2012  1/1/201380000410002/1/2013  3/1/2013  4/1/2013  5/1/2013  6/1/2013  7/1/2013  8/1/2013  9/1/2013  10/1/2013  11/1/2013  12/1/2013  1/1/20147000036000

What I am trying to do is fill the empty values of the remaining dates.

The value in the first month for each year is actually the total for the whole year. So, "100,000" profit is profit for the whole year. I am splitting this "100,000" into 12 months to get a prediction of profit by month. However I need assistance in filling all the remaining empty rows in that year so that they decrease over time and do not overlap with the following years first month.

By that I mean that the December month of the prior year should be greater than the first month of the next year. This is to prevent staggering graphics

Thank you.

devalex · Answer

So I'm trying to have the values decrease progressively by month. In the example you showed they are decreasing but only by year. I need them to decrease incrementally each month. No month should have the same value.

aatalai · Answer

@devalex I don't exactly follow but does this help?

How to fill empty rows with a formula that decrease in value over time.yxmd