Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
howard holtz wrote:
I have an Excel worksheet whose first column entries are DEC,NOV,OCT...JAN. I wish to reverse this column along with all of the other columns to JAN, FEB,..DEC,etc Are these dates formatted to show month abbreviation, or are they text? If the former, you might could just sort the list ascending. If the latter it might be easiest to do it by hand, but another way would be to build a little table somewhere like DEC 12 NOV 11 etc. Then use VLOOKUP to associate a number with the month, and sort on the number. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I reverse the order of a column or row? | Excel Discussion (Misc queries) | |||
Reverse order of numbers in a column | Excel Discussion (Misc queries) | |||
How to reverse the order of data in a single column in Excell? | Excel Discussion (Misc queries) | |||
How do I reverse the order (sequence) of a column of data in Excel | Excel Worksheet Functions | |||
Reverse order in column | Excel Worksheet Functions |