Min function excluding zero
 

hi, i have a set of positive numbers (randomly generated) which includes a
zero . I want to pickout the Min from them which excludes zero. i.e, Min
greater than zero.

My second question is
=if(or(a1=1,a1=2),"A","B")) I modified it to
=if(a1={1,2},"A","B"). But This formula is true only for a1=1
any suggestions.
Thank you all
With regards
Sridhar

Min function excluding zero
 

Try one of these for the MIN:

=SMALL(A1:A10,1+COUNTIF(A1:A10,0))

Or this array formula**:

=MIN(IF(A1:A100,A1:A10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

My second question is
=if(or(a1=1,a1=2),"A","B")) I modified it to
=if(a1={1,2},"A","B"). But This formula is true only for a1=1

Try it like this:

=IF(OR(A1={1,2}),"A","B")

--
Biff
Microsoft Excel MVP


"yshridhar" wrote in message
...
hi, i have a set of positive numbers (randomly generated) which includes
a
zero . I want to pickout the Min from them which excludes zero. i.e, Min
greater than zero.

My second question is
=if(or(a1=1,a1=2),"A","B")) I modified it to
=if(a1={1,2},"A","B"). But This formula is true only for a1=1
any suggestions.
Thank you all
With regards
Sridhar

Min function excluding zero
 

Thank you Mr. Biff. It solved my problem.
With regards
Sridhar

"T. Valko" wrote:

Try one of these for the MIN:

=SMALL(A1:A10,1+COUNTIF(A1:A10,0))

Or this array formula**:

=MIN(IF(A1:A100,A1:A10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

My second question is
=if(or(a1=1,a1=2),"A","B")) I modified it to
=if(a1={1,2},"A","B"). But This formula is true only for a1=1

Try it like this:

=IF(OR(A1={1,2}),"A","B")

--
Biff
Microsoft Excel MVP


"yshridhar" wrote in message
...
hi, i have a set of positive numbers (randomly generated) which includes
a
zero . I want to pickout the Min from them which excludes zero. i.e, Min
greater than zero.

My second question is
=if(or(a1=1,a1=2),"A","B")) I modified it to
=if(a1={1,2},"A","B"). But This formula is true only for a1=1
any suggestions.
Thank you all
With regards
Sridhar

Min function excluding zero
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"yshridhar" wrote in message
...
Thank you Mr. Biff. It solved my problem.
With regards
Sridhar

"T. Valko" wrote:

Try one of these for the MIN:

=SMALL(A1:A10,1+COUNTIF(A1:A10,0))

Or this array formula**:

=MIN(IF(A1:A100,A1:A10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

My second question is
=if(or(a1=1,a1=2),"A","B")) I modified it to
=if(a1={1,2},"A","B"). But This formula is true only for a1=1

Try it like this:

=IF(OR(A1={1,2}),"A","B")

--
Biff
Microsoft Excel MVP


"yshridhar" wrote in message
...
hi, i have a set of positive numbers (randomly generated) which
includes
a
zero . I want to pickout the Min from them which excludes zero. i.e,
Min
greater than zero.

My second question is
=if(or(a1=1,a1=2),"A","B")) I modified it to
=if(a1={1,2},"A","B"). But This formula is true only for a1=1
any suggestions.
Thank you all
With regards
Sridhar