Sorting Columns with a Formula

[mtatlow]

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

 

[Jim Cone]

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 )



<[email protected]>
wrote in message
news:092ca0ad-db1b-4d1e-8b45-a9784fcabbcd@db5g2000vbb.googlegroups.com...