=SMALL(A1:A9,COUNTIF(A1:A9,0)+1)


"The Countryman" wrote:

I am struggling to find a formula that will allow me to find the lowest
number within a range that doesn't include either blanks or 0's in the
answer. Does anyone know of a simple solution?

Thanks
--
Yorkie