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