Sorting Columns with a Formula

  • Thread starter Thread starter mtatlow
  • Start date Start date
M

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
 
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...
 
Back
Top