I am working with a huge MS Excel 2010 spreadsheet to track projects and tasks within a project. Each task may have a different delivery date. I would like to group the data by project then sort the projects by earliest delivery date of any task within that project.

So a simple sample of the data looks as follows:

COLUMN A COLUMN B COLUMN C
7/28/2011 Deploy Project Task a
7/14/2011 AD Project Task b
7/30/2011 AD Project Task a
7/18/2011 Deploy Project Task d
7/20/2011 Condolidation Project Task f
7/28/2011 Deploy Project Task c

etc etc

So, what I am trying to acomplish is how to Group the data in COLUMN B (Project) then sort the Project Groups and each task within that Group by COLUMN A (Delivery date of task) while respecting the groupings. In other words the end result would look something like this:

7/14/2011 AD Project Task b
7/30/2011 AD Project Task a

7/18/2011 Deploy Project Task d
7/28/2011 Deploy Project Task a
7/28/2011 Deploy Project Task c

7/20/2011 Condolidation Project Task f

Any advice on how to easily acomplish this?