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(A10,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(A10,A1,"").........then in A3 put this
formula..............=MIN(2:2)


Vaya con Dios,
Chuck, CABGx3


"Tommy" wrote in message
...
I have a cell that has number ranges from -37 to 88, what is the formula
to
show the lowest positive number.

Thank You