# sorting data across multiple columns

G

#### Guest

I have lets say 10 columns each labeled , A, B, C, through J.
Each column contains 10 random serial numbers
How can I sort the 10 columns in ascending or descending order so that all
numbers in the 10 columns are sorted within the 10 rows in each column,
from this:
A B C D .....
10 23 24 19
2 7 18 21
17 12 11 18 ETC..

to this:
A B C D...
1 6 11 16
2 7 12 17
3 8 13 18
4 9 14 19
5 10 15 20

J

#### Jim Cone

S...,

My Excel add-in "Special Sort" - rel 1.40, should do what you want.
color, prefix, suffix or middle (where you specify the length/position)
dates, numbers, length, reverse, random and just added is the
Table sort feature that sorts the selection across rows or down columns.

It resembles and responds somewhat like the built-in Excel utility.
Comes with a 2 page install/use Word file.
It is available - free - upon email request.
Remove XXX from my email address.

Regards,
Jim Cone
San Francisco, USA

"Spiderman"
<[email protected]>
wrote in message
I have lets say 10 columns each labeled , A, B, C, through J.
Each column contains 10 random serial numbers
How can I sort the 10 columns in ascending or descending order so that all
numbers in the 10 columns are sorted within the 10 rows in each column,
from this:
A B C D .....
10 23 24 19
2 7 18 21
17 12 11 18 ETC..

to this:
A B C D...
1 6 11 16
2 7 12 17
3 8 13 18
4 9 14 19
5 10 15 20

G

#### Guest

Hi,

Let us say, your data are in the grid A1:J10. In some cell (say L1) [this
would be the top left-hand side cell of the new grid where the sorted numbers
would go], enter the following formula:

=SMALL(\$A\$1:\$J\$10,(COLUMN()-COLUMN(\$L\$1))*10+ROW()-ROW(\$L\$1)+1)

Fill-in the formula down the next 9 rows and across the next 9 columns.

For sorting the numbers in descending order, change the "SMALL" in the
formula to "LARGE".

Regards,
B. R. Ramachandran