FWIW, also assumes only non-negative numbers.

In article ,
BoniM wrote:

Here's one way:
=SMALL(A1:A20,COUNTIF(A1:A20,0)+1)
counts the number of zero's and gives you the next smallest number that
isn't zero. This assumes values in column A, thru row 20, adjust as
necessary.