minimum formual help
You can try this non-array approach:
=SMALL(B1:B13,COUNTIF(B1:B13,0)+1)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"scott" wrote in message
...
Simple but can not get this. I have just 12 cells need to pick out the
minimum excluding 0. Tried =min(if(b1:b13<0)) and entered as an
arrary.comes
back as error with 0 highlighted. Any help would be appreciated
Thanks Scott
|