# Finding Non Zero Smallest Numbers

Feb 16, 2008Find smallest numbers in the range ignoring zeros.

I want it returned as value "1", all others - as value "0".

Example: range A1:J1 contains - 5,0,7,3,6,5,8,0,9,3

desirable result in the range A2:J2 - 0,0,0,1,0,0,0,0,0,1