Sorting Columns with a Formula

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
 
J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top