Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
![]()
I use Excel 2003.
I have a file, with about 1500 sets of dates in adjacent cells in rows. I would like to sort that data. I suspect I am going to have to do so in VBA, but would prefer worksheet instructions. This is the rendering of a couple of rows of that data: 06-Nov-12 04-Dec-12 08-Jan-13 05-Feb-13 05-Mar-13 01-Oct-13 10-Nov-12 08-Dec-12 09-Feb-13 09-Mar-13 12-Oct-13 I want the output in month order. e.g. January - December, ignoring year and day. So the output from those rows would be 08-Jan-13 05-Feb-13 05-Mar-13 01-Oct-13 06-Nov-12 04-Dec-12 09-Feb-13 09-Mar-13 12-Oct-13 10-Nov-12 08-Dec-12 I don't even know how to sort data in rows rather than in columns. ;( -- Walter Briscoe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort 2 dimensional Array, copy a row | Excel Programming | |||
Export 1-dimensional array values to a two-dimensional table? | Excel Programming | |||
Multi-column two-dimensional quick sort | Excel Programming | |||
Sort on two columns in two dimensional array | Excel Programming | |||
sort multi-dimensional array on numeric data? | Excel Programming |