ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automatically sorting columns by date (https://www.excelbanter.com/excel-discussion-misc-queries/206038-automatically-sorting-columns-date.html)

Schizoid Man

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.



Bernd P

Automatically sorting columns by date
 
Hello,

An example:
http://www.sulprobil.com/html/sorting.html

Regards,
Bernd


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com