Sort by group

[DexterV]

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 thir
sort in "chunks". In other words, it would sort the groups by the firs
date of each group of events.

Thank

 

[Ron Coderre]

I think a Pivot Table might work for you:

Select the table range
Data>Pivot Table
-Excel List.....[Next]
-Range is already selected.....[Next]
-[Layout]:
----->ROW: Event
----->DATA: Date
Double-Click Date and select MIN and format as date
Select Pivot Table location......[Finish]

That will generate a list of events with the earliest date for that
event.

Does that help?

Ron

 

[Ron Coderre]

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

 

[DexterV]

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?

 

[Ron Coderre]

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