Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Column Sorting
Hi,
For a more general solution try this. Assume that your data is in the range A1:E5 Enter the following formula in a cell and copy it down five rows and over five columns: =SMALL($A$1:$E$5,ROW(A1)+5*(COLUMN(A1)-1)) Note this will work even if the number are not well ordered as in your example. The sorting solution would fail if swapped the 1 and the 25, but this formula will not. You can adjust the arguments of the formula to address other ranges. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "chinoyvr" wrote: Using Excel 2003, want to sort example listed below...there are no headers... 25 20 15 10 5 24 19 14 9 4 23 18 13 8 3 22 17 12 7 2 21 16 11 6 1 Basically, each number is on a different row and column orderly. Is there a way to sort all of it and put it in proper order from lowest number and up first by column, then by row...so that the outcome would look like; 1 6 11 16 21 2 7 12 17 22 3 8 13 18 23 4 9 14 19 24 5 10 15 20 25 The example I used is small as the spreadsheet I work on is about 20 columns wide and 29 rows deep. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting a Pivot Table Column that is not the first column... | Excel Worksheet Functions | |||
Sorting Data From One Column into Multiple Columns | Excel Worksheet Functions | |||
How do I limit sorting a column to the column? | Excel Worksheet Functions | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
Right column doesn't change when sorting left column. | Excel Discussion (Misc queries) |