I have two sets of months in a row, each column in that row is the next month. The first set of months is Jan thru Dec. The second set is two years of Jan thru Dec.
In the first 12 months only one month will have a value, the rest is zeros. I want a formula that repeats the value of that one month for twelve months in second (two year) 24 months.
Jan Feb Mar Apr May..... Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr
50 0 50 50 50 50 50 50 50 50 50 50 50 50 0 0 0
60 0 0 0 0 60 60 60 60 60 60 60 60 60 60 60 60
The month columns are actually dates 1/1/2017 2/1/2017 etc,
Having no luck.
Thanks,
Chip
In the first 12 months only one month will have a value, the rest is zeros. I want a formula that repeats the value of that one month for twelve months in second (two year) 24 months.
Jan Feb Mar Apr May..... Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr
50 0 50 50 50 50 50 50 50 50 50 50 50 50 0 0 0
60 0 0 0 0 60 60 60 60 60 60 60 60 60 60 60 60
The month columns are actually dates 1/1/2017 2/1/2017 etc,
Having no luck.
Thanks,
Chip
Last edited: