I'm new at this but i think =MIN(A1:R1) in the cell where you want the result
should find the lowest value.
--
Browny


"Nigel Toates" wrote:

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