View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default reverse the order of data in a column.(1,2,5 goes to 5,2,1)

Are those text strings or actual dates formatted to MMM?

If dates, just sort them under datasort.

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
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