You guys rock! The formula works perfectly and will save me hours of manual
searching (and worry that I did it right). The worksheet is already at
column AO and growing wider. Thanks for your quick response.

"Biff" wrote:

Hi!

Try this:

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=MIN(IF(A1:C50,A1:C5))

Biff

"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.