Quick Question re column allocation

[Brando123]

Hi Guys,

Column A has $ amounts down the page.

Columns C-N have months Jan - Dec.

Column B has numbers 1-12 down the page (not in any particular order).

I would like to be able to create a formula for cells in columns C-N so that I can simply enter a number in column B (i.e. number 1-12, being months 1-12), and excel will pick the $ amount from column A and automatically assign it to the corresponding month column.

 

[mikerickson]

In C2 put the formula =IF(COLUMNS($A2:A2)=$B2, $A2, "")
Then drag the formula right and down

 

[Brando123]

Thanks mate, that works great!

 

[Brando123]

To take this one step further, I would like to insert another column between the existing columns B&C. This column will be called "month span", and the numbers entered will determine how many months (columns) the $ amount in column A should be allocated across.

In other words, if cell A2 is $1200, and the new column C (i.e. "month span") cell C2 shows 12, then excel will allocate $100 to each month Jan-Dec.

Any ideas?

 

[mikerickson]

If A2 has 1200 and C2 is 6, which months should get $200? e.g. should August get $0 or $200?
Is column B still in random order? Can it be ordered?

 

[Brando123]

If A2 has 1200 and C2 is 6, which months should get $200? e.g. should August get $0 or $200?
Is column B still in random order? Can it be ordered?

Column B is called "Month Start", and is the month that the project expenditure starts.

Column C is called "Month Span", and is the number of months that the $ expenditure needs to be allocated over.

So, assuming B2 is 3, then the expenditure starts in March (3rd month) and is $200 per month for six months March - August inclusive.

 

[Brando123]

Hi guys,

Still looking for some help with this one please.