Sort by quarter

Sheila G.

New Member
Joined
May 6, 2008
Messages
12
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
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,770
Office Version
  1. 2010
Platform
  1. Windows
You could use a formula in another column to extract the quarter, e.g.,

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

Watch MrExcel Video

Forum statistics

Threads
1,109,049
Messages
5,526,488
Members
409,703
Latest member
nbkqsj7

This Week's Hot Topics

Top