Try one of these. both formulas are array formulas and need to be entered
using the key combination of CTRL,SHIFT,ENTER (not just ENTER):

If all the values are positive and there are no TEXT values in the range:

=MIN(IF(A1:A10,A1:A10))

Another way that excludes TEXT values and negative numbers:

=MIN(IF(A1:A100,A1:A10))

Biff

"bookman3" wrote in message
...
Hi

I have a list of values including zeros. How can I find the minimum value
in
the list that is greater than zero.

Regards
--
bookman