Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically sorting columns by date
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with sorting by date columns | Excel Discussion (Misc queries) | |||
AUTOMATICALLY DATE COLUMNS WITH DIFFERENT DATES | Excel Discussion (Misc queries) | |||
Sorting automatically by columns | Excel Discussion (Misc queries) | |||
In Excel, sorting columns automatically by clicking column title | Excel Discussion (Misc queries) | |||
sorting automatically | Excel Worksheet Functions |