Min function excluding zero

[Guest]

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

 

[T. Valko]

Try one of these for the MIN:

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

Or this array formula**:

=MIN(IF(A1:A10>0,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")

 

[Guest]

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

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[Phillip Quade]

Mr. Biff,
My question may not pertain to this formula, but your responses to other questions are awesome.

My question is complex for me. I want to look through column B and find the values less than a value input in a cell F22. Then look through column C to find values greater than input in cell F22. Then look through column F find a value greater than a value calculated in cell F23. Then look through column G find the value less than a value calculated in cell F23. Through this it will lead to one specific row.

 

[Pete_UK]

Biff seems to have stopped posting in the newsgroups now, though he is
still a regular on the MS Forums.

I'm not sure what it is that you want to do. Are you looking for 4
different numbers? Please describe your problem with reference to a
few examples.

Hope this helps.

Pete