Sort the column in the normal way, select a cell therein and click either
the A-Z or Z-A icon on the tool bar, then Select a cell in the column, then
do Data > Filter > AutoFilter, and then click the dropdown arrow at the top
of the column and select Custom > greater than > 0...........to return to
all the data to view, just do Data > Filter > AutoFilter again........it's a
toggle.

Vaya con Dios,
Chuck, CABGx3


"Tommy" <Tommy@discussions.microsoft.com> wrote in message
news:7EFA019A-1BB2-4B86-9EC9-D4AFBCB9204D@microsoft.com...
> CLR
>
> It was a column and it worked great. One more question is there a way to
> sort the same numbers from lowest above 0. example 55, 56, 70, 71 and
so
> on.
>
> Thank you
>
> "CLR" wrote:
>
> > Not sure what you mean by having a "cell" with a range of numbers in
> > it........ an example would be appreciated if that's really the
case.......
> >
> > On the other hand, if you meant that you have a "Column" with a range of
> > numbers in it, then assuming it's column A, use a helper column in
column B1
> > put this formula.........=IF(A1>0,A1,"") and copy it down, then in C1
put
> > this formula.........=MIN(B:B)
> >
> > If you meant you have a "row" with a range of numbers in it, then
assuming
> > it's Row 1, put this formula in A2 and copy
> > across.......=IF(A1>0,A1,"").........then in A3 put this
> > formula..............=MIN(2:2)
> >
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> > "Tommy" <Tommy@discussions.microsoft.com> wrote in message
> > news:D97567B8-E81D-48A6-B6F8-1B8CFF668646@microsoft.com...
> > > I have a cell that has number ranges from -37 to 88, what is the
formula
> > to
> > > show the lowest positive number.
> > >
> > > Thank You
> >
> >
> >