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




"Spiderman" wrote:

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