Need help with MIN IF AND

Pecoflyer · #1 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 · #2 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.