Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|