=MIN(IF({0,0,1,2}0,{0,0,1,2}))
....entered as an array formula.
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(XL Companion add-in: compares, matches, counts, lists, finds, deletes...)
"kittronald"
wrote in message
...
How could you get the smallest number greater than zero in the array
constant {0,0,1,2} ?
In this case, the answer would be 1.
- Ronald K.