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
>
>
>