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

Hi Scott
try array entering the formula
{=MIN(IF(B1:B13<0, B1:B13,""))}

To enter, or amend an array formula, use Control+Shift+Enter (CSE) not just
Enter.
Do not type the curly braces { } yourself, if you use CSE, Excel will
insert them for you.

--

Regards
Roger Govier

"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

Try this entered as an array formula =MIN(IF(B1:B13<0,B1:B13))

Tyro
"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

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