2 dimensional date sort
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
select your rows = Data = Sort = Options = Sort Columns
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|