min if

[Rene]

I'm looking for a formula that will find the MIN if 'b' is in the m column

=MINIF(M2:M10,"b",F2:F10)

excel 2007

 

[Bernard Liengme]

=MIN(IF(M2:M10="b",F2:F10))
this is an array formula so commit it with SHIFT+CTRL+ENTER not just a
simple ENTER; Excel will enclose it in braces {}
best wishes

 

[T. Valko]

Try this array formula** :

=MIN(IF(M2:M10="B",F2:F10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

 

[Rene]

Thanks to you both

Try this array formula** :

=MIN(IF(M2:M10="B",F2:F10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks to you both

 

[untouchable]

What if you have 2 columns you need to check?

M2:M10="B" and N2:N10>5??

 

[T. Valko]

Try this array formula** :

=MIN(IF(M2:M10="B",IF(N2:N10>5,F2:F10)))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.