try this. It is an array formula so must be entered/edited with
ctrl+shift+enter and will not work on full columns.

=MIN(IF(D1:D1000,D1:D100))

--
Don Guillett
SalesAid Software

"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