View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Schizoid Man Schizoid Man is offline
external usenet poster
 
Posts: 4
Default Automatically sorting columns by date

Hi,

I have the following table and a slight ordering problem. Each of the rows
A, B, C, etc has data associated with 5 fixed dates - from 20-Dec-09 to
20-Dec-18. In addition there is one "floating" column added to the end. In
this example, it is the data for column 20-Dec-10.

20-Dec-09 20-Dec-11 20-Dec-13 20-Dec-15 20-Dec-18 20-Dec-10
A 84 49 88 91 26 82
B 9 68 39 89 50 59
C 45 5 46 69 41 38
D 35 28 70 69 47 59

The dates for the "floating" column always change - it could be any date
before, after or in between the five fixed dates. I'd like to sort this data
so that the columns are ordered by dates in increasing order from left to
right.

Any suggestions?

Thanks.