View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Saintsman Saintsman is offline
external usenet poster
 
Posts: 81
Default year quarters === Financial Year

I group months by Quarter, but I need to group the Quarter by Financial Year
Quarter Finance year
ie - 2007Q2 = 2007-08
2008Q1 = 2007-08
2008Q2 = 2008-09

I then carry out a SUMPRODUCT to pick up values which involve looking up
quarter values

I need to maintain the form as I have used this elsewhere in my workbook &
don't want to change anything

Thanks in advance

Saintsman