reverse the order of data in a column.(1,2,5 goes to 5,2,1)

[howard holtz]

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

 

[Gord Dibben]

Are those text strings or actual dates formatted to MMM?

If dates, just sort them under data>sort.

If text strings, in a helper column enter 1 through 12 then sort descending
on that column...............after first selecting all columns.


Gord Dibben MS Excel MVP



On Sat, 20 Dec 2008 16:20:00 -0800, howard holtz <howard

 

[Jim Cone]

Enter the month names, in proper order, in adjacent cells.
Then Tools | Options | Customs Lists and create a custom list.
Once you do that, you can then sort the month names using the custom
list as the sort order. Click the Options button in the sort dialog to find
and specify the custom list.
--
Jim Cone
Portland, Oregon USA



"howard holtz" <howard
wrote in message
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