Hi Barbara
You can use this array formula
=MIN(IF(A1:A100,A1:A10))
See
http://www.cpearson.com/excel/array.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Barbara" wrote in message ...
I have a range of cells where I would like to find the minimum value greater
than 0.
For example:
18
12
0
16
19
I need a formula to look at the entire range and result in the lowest value,
in this case 12.
Thanks for the help.