Sort by quarter

[Sheila G.]

I have a large data set (1995-2011) and I need to sort each year by quarter and group the quarters together for trending. Anybody have any ideas on some code? THX-SG

 

[shg]

You could use a formula in another column to extract the quarter, e.g.,

=int((month(a2)-1)/3) + 1

 

[Sheila G.]

Thanks shg.