min if
 

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

min if
 

=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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Rene" wrote in message
...
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

min if
 

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)

--
Biff
Microsoft Excel MVP


"Rene" wrote in message
...
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

min if
 

Thanks to you both

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"Rene" wrote in message
...
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

min if
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Rene" wrote in message
...
Thanks to you both

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"Rene" wrote in message
...
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

min if
 

What if you have 2 columns you need to check?

M2:M10="B" and N2:N105??


"Bernard Liengme" wrote:

=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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Rene" wrote in message
...
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

min if
 

Try this array formula** :

=MIN(IF(M2:M10="B",IF(N2:N105,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.

--
Biff
Microsoft Excel MVP


"untouchable" wrote in message
...
What if you have 2 columns you need to check?

M2:M10="B" and N2:N105??


"Bernard Liengme" wrote:

=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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Rene" wrote in message
...
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