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