One way:
=IF(COUNTIF(A1:A25,""&0)=0,"No numbers greater than 0",
SMALL(A1:A25,COUNTIF(A1:A25,"<="&0)+1))

Another:
=IF(COUNTIF(A1:A25,""&0)=0,"No numbers greater than 0",
MIN(IF(A1:A250,A1:A25)))

The second formula is an array formula. Hit ctrl-shift-enter instead of enter.
If you do it correctly, excel will wrap curly brackets {} around your formula.
(don't type them yourself.)


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

--

Dave Peterson