View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default reverse the order of data in a column.(1,2,5 goes to 5,2,1)

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