Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freezing columns labels while sorting columns | New Users to Excel | |||
sorting 4 columns | Excel Worksheet Functions | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
Sorting columns | Excel Discussion (Misc queries) | |||
Sorting more than 3 columns - is it possible? | Excel Programming |