Need help with MIN IF AND

		Microsoft Office Forums > Microsoft Excel > Excel
Need help with MIN IF AND

FAQ

Thread Tools

Display Modes

06-27-2015, 09:22 AM

Pecoflyer

Windows 7 64bit Need help with MIN IF AND

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

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 ?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Other Forums: Access Forums

All times are GMT -7. The time now is 06:43 PM.