This should do what you want:
=IF(COUNT(A:A)=ROWS($1:1),SMALL(A:A,ROWS($1:1))," ")

Regards,
Ryan---


--
RyGuy


"Amstro2006" wrote:

Hello friends: I need some help. I know how to do sorting in general but I am
not an excel expert. The problem is as shown below:

37.66 38 38 38 38 38.25
97.2 100 92 100 78.7 100
.5 38.25 55 88.5 100 16
23.75 10 56 10 18.75 19.2
53.5 8.4 100 9.75 10.75 43.75
56.25 9 10 12.5 12.86 16

The above is a smaller version. I have almost 100 columns or more. I want to
sort each column from 'smallest to largest'. They are all independent. I do
not want to go column by column sorting each of them. Is there a way to sort
the entire thing in such a way that each column has its contents sorted from
small to large.

I appreciate all the help. Thanks in advance.

amstro.