Thread: Sort by group

In my table, I have a column with dates and a second one with events. The table is sort by events, then by dates.

Now, I would like to know if there is a possibility to make a third sort in "chunks". In other words, it would sort the groups by the first date of each group of events.

Thanks

You might want to try using this Pivot Table approach:

Assumptions are that the data is sorted by group, then by date.
This example is for a list in Cells A1:B100, A1 and B1 contain column headings Event and Date, respectively

Add a column to the right of the table (col C) and label it StartDate
Run this formula in C2 and copy it down:
=VLOOKUP(A28,$A$2:$B$100,2,1)

Then:
Select the table range, A1:C100

Data>Pivot Table
-Excel List.....[Next]
-Range is already selected.....[Next]
-[Layout]:
----->ROW: StartDate, Event, Date
----->DATA: Date

Double-Click StartDate and select Advanced, Sort Ascending
Double-Click Date (in the DATA section) and select COUNT

Select the Pivot Table location......[Finish]

That will generate a grouped list of events sorted by the events with the earliest starting dates.

Does that help?

Ron

Thanks Ron for that procedure.

I recreated your example, but Excel tells me there is an error in the first formula : =VLOOKUP(A28,$A$2:$B$100,2,1)

Any idea?

Formula typo
=VLOOKUP(A28,$A$2:$B$100,2,1)

should be
=VLOOKUP(A2,$A$2:$B$100,2,1)

(either my fingers are too big or the keyboard is too small, or both)

Regards,
Ron