How could you get the smallest number greater than
zero in the array constant {0,0,1,2} ?

If it is an array constant (emphasis on the word constant), then why would
you need to do anything... you can see it is 1 and, because it is a
constant, it will always be 1. Did you by any chance attempt to simplify
your *real* question for us (and perhaps you took that simplification too
far)? If so, you should not do that... all that will get you are answers to
questions you do not really care about.

Rick Rothstein (MVP - Excel)