Assuming there are no negative numbers in the range:

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

--
Biff
Microsoft Excel MVP


"Nigel Toates" wrote in message
...
I have a row of 19 cells that have many zeros in it but I need to find the
lowest value that is greater than "0"

The problem comes from having 19 months of sales figures and I want to
find
the lowest month value we had sales in.

Thanks Nigel