I want to find the Min value of a range that is greater than 0.

Min (A1:A5) but ingore zero values.

Bruce

One way ..

Try: =MIN(IF(A1:A50,A1:A5))
Array-enter the formula,
i.e. press CTRL+SHIFT+ENTER
instead of just pressing ENTER
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Bruce" wrote in message
...
I want to find the Min value of a range that is greater than 0.

Min (A1:A5) but ingore zero values.

Bruce