Microsoft Office Forums - View Single Post - Need help with MIN IF AND

Thread: Need help with MIN IF AND

View Single Post

Old

06-27-2015, 06:29 AM

tinfanide

tinfanide is offline

tinfanide uses Windows 7 64bit

Windows 7 64bit tinfanide uses Office 2010 32bit

tinfanide uses Office 2010 32bit

Office 2010 32bit

Expert

The original poster

Join Date: Aug 2011

Posts: 312

tinfanide is on a distinguished road

Default

Quote:

Originally Posted by Pecoflyer

View Post

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

Reply With Quote