sort a column in ascending order
=IF(ISERROR(LARGE(A:A,ROW())),"",LARGE(A:A,ROW()) )

You might want tho replace LARGE with SMALL.

Biff

"Gary''s Student" wrote in message
...
Hi Longtime:

Here is a solution that's fun to play with:

Say you are entering numbers in an arbitrary order in column A. You can
enter them at the top of the column. You can enter them at the bottom of
the
column. You can leave spaces between entries. Doesn't matter. In B1
enter:

=IF(ISERROR(LARGE(A:A,ROW())),"",LARGE(A:A,ROW()))
and copy down

Whatever you have entered in column A or whatever you will enter in column
A
will automatically appear in sorted order in column B.

Column B will respond to changes in column A in an automatic fashion. It
even catches ties.
--
Gary's Student


"Longtime" wrote:



"Longtime" wrote:

Is there a way to automatically sort a column in ascending order while
entering numbers so that the column is sorted when last number is
entered.
Appreciate all help.
Sorry, that did not do it