Assuming the data is in A1:A10, try:

=MIN(IF(A1:A10<0,A1:A10))
array entered using Cntrl+Shift+Enter

or
=SMALL(A1:A10,IF(COUNTIF(A1:A10,"<0"),1,COUNTIF(A1 :A10,0)+1))


"bookman3" wrote:

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