Sorting Columns with a Formula
 

Hello,

I need to sort columns using a formula, the data is listing in columns
as follows

Column A Column B Column C Column D
Column E
12/31/2010 12/31/2011 12/31/2011 3/31/2011 3/30/2012


I would like a formula that would sort the columns


Column A Column B Column C Column D
Column E
12/31/2010 12/31/2011 3/31/2011 12/31/2012 3/31/2012

Is this possible?

Thanks

Sorting Columns with a Formula
 

You can use Excel's sort utility to sort across.
Unfortunately, it will only sort one row at a time.
It can sort multiple selected rows across, but all rows sort with the key row.
The Excel sort box (dialog) contains an "Options" button that provides access to he "left to right"
sort option.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
Special Sort Excel add-in (30 ways to sort )




wrote in message
...
Hello,

I need to sort columns using a formula, the data is listing in columns
as follows

Column A Column B Column C Column D
Column E
12/31/2010 12/31/2011 12/31/2011 3/31/2011 3/30/2012


I would like a formula that would sort the columns

Column A Column B Column C Column D
Column E
12/31/2010 12/31/2011 3/31/2011 12/31/2012 3/31/2012

Is this possible?
Thanks