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