=MIN(IF(A1:A100,A1:A10))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"perplexed" wrote in message
...
I am trying to analyze a large block of data where not all columns have an
entry. I want to find the lowest value (but greater than zero or a blank
cell) and write it into a separate column.