Take a look at
http://www.mrexcel.com/tip011.shtml
for a good overview of array or CSE formulas.
The formula can also be written as
=MIN(IF(A1:A4<>0,A1:A4))
This basically says you want the minimum of non zeros number.
=MIN(IF(A1:A4>=0,A1:A4))
would give you the minimum of postive number (including zeros).
Back to the first formula, if you had 9,0,-12, and 7 in a range the formula would do this:
=MIN(IF({TRUE;FALSE;TRUE;TRUE},{9;0;-12;7}))
=MIN({9;FALSE;-12;7})
It will only take the minimum of the true values, which -12 in this case.
Hope that helps a little. I can tell what time it is, but don't always know how to make a watch.
This message was edited by IML on 2002-10-11 10:40