2 dimensional date sort

  • Thread starter Thread starter Walter Briscoe
  • Start date Start date
W

Walter Briscoe

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. ;(
 
Hi Walter,

Am Sun, 2 Dec 2012 12:44:18 +0000 schrieb Walter Briscoe:
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
Click to expand...

select your rows => Data => Sort => Options => Sort Columns


Regards
Claus Busch
 
Back
Top