welshwonder
New Member
- Joined
- Feb 20, 2012
- Messages
- 15
Hi,
I have costs over a timeline in months with their assosiated quarter and year numbers like below on a seperate row underneath the month row:
Month 1 Month 2 Month 3 Month 4 etc etc
Y1 Qtr1 Y1 Qtr1 Y1 Qtr1 Y1 Qtr2 etc etc
Monthly costs........................ etc etc
What I need to do is "roll up" the costs (60 months worth) into the correct quarter. I can do the rollup bit, but how do I get a timeline in quarters without any blanks using worksheet functions? i.e.
Y1 Qtr1 Y1 Qtr2 Y1Qtr 3 Y1Qtr4 Y2 Qtr1 Y2 Qtr2 Y2 Qtr3 Y2 Qtr4 etc etc
Thanks in advance....
I have costs over a timeline in months with their assosiated quarter and year numbers like below on a seperate row underneath the month row:
Month 1 Month 2 Month 3 Month 4 etc etc
Y1 Qtr1 Y1 Qtr1 Y1 Qtr1 Y1 Qtr2 etc etc
Monthly costs........................ etc etc
What I need to do is "roll up" the costs (60 months worth) into the correct quarter. I can do the rollup bit, but how do I get a timeline in quarters without any blanks using worksheet functions? i.e.
Y1 Qtr1 Y1 Qtr2 Y1Qtr 3 Y1Qtr4 Y2 Qtr1 Y2 Qtr2 Y2 Qtr3 Y2 Qtr4 etc etc
Thanks in advance....