Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 -- DexterV ------------------------------------------------------------------------ DexterV's Profile: http://www.excelforum.com/member.php...o&userid=24969 View this thread: http://www.excelforum.com/showthread...hreadid=384949 |
#2
|
|||
|
|||
I think a Pivot Table might work for you: Select the table range DataPivot 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 ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=384949 |
#3
|
|||
|
|||
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 DataPivot 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 -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=384949 |
#4
|
|||
|
|||
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? -- DexterV ------------------------------------------------------------------------ DexterV's Profile: http://www.excelforum.com/member.php...o&userid=24969 View this thread: http://www.excelforum.com/showthread...hreadid=384949 |
#5
|
|||
|
|||
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 -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=384949 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort a group of calculated cells in Excel? | Excel Worksheet Functions | |||
Excel sort option disabled--file name followed by "group" at top . | Excel Discussion (Misc queries) | |||
Trying to group cells so that I can sort the upper most cell with. | New Users to Excel | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
vba to sort group copy paste to another sheet | Excel Worksheet Functions |