Monthly to quarterly timeline

[welshwonder]

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....

 

[welshwonder]

Ok, I solved it myself in the end, so here it is if anyone else has this issue in the future:

{=INDEX($AP$10:$FH$10, MATCH(0, COUNTIF($AO$55:AO55, $AP$10:$FH$10), 0))}

I used an array formula (hold down Ctrl, Shift and Enter when you have entered the formula in the formula bar).

Where AP10:FH10 is the area where the Financial Year Qtr numbers are held and AO55:CD55 is the new row where you want the Financial Year Qtr numbers to be without the duplicates.