Need help with MIN IF AND

Pecoflyer · #1 06-26-2015, 07:33 AM

A non array solution

Code:

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

EDIT corrected typo

tinfanide · #2 06-27-2015, 06:29 AM

Quote:

Originally Posted by Pecoflyer

A non array solution

Code:

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

EDIT corrected typo

Thanks. But if the array is like this:

From A1 to A6:
4,0,5,1,2,1

Then

Code:

COUNTIF($A$1:$A$6,1)
' will return 2

Pecoflyer · #3 06-27-2015, 09:22 AM

Quote:

Originally Posted by tinfanide

Thanks. But if the array is like this:

From A1 to A6:
4,0,5,1,2,1

Then

Code:

COUNTIF($A$1:$A$6,1)
' will return 2

Yes, and what is wrong about it? Aren't you looking for the smallest value different from 0 or 1 ?

tinfanide · #4 06-27-2015, 09:53 PM

Quote:

Originally Posted by Pecoflyer

Yes, and what is wrong about it? Aren't you looking for the smallest value different from 0 or 1 ?

Nope. I've confused myself. You're right.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode