Min If that ignores blanks

[scotthannaford1973]

Hi

I have the formula below that brings up the minimum in a range (BA) where another range (AZ) equals a particular cell (BD) - which works - except as here are some blanks in BD, it includes the blank as the minimum. How do I exclude blanks? Thanks!


=MIN(IF($AZ$8:$AZ$401=BD10, $BA$8:$BA$401))

 

[Fluff]

Try

=MIN(IF(($AZ$8:$AZ$401=BD10)*($BA$8:$BA$401<>""), $BA$8:$BA$401))

 

[sparky2205]

Would this also work Fluff? For my own learning.

=MINIFS($BA$8:$BA$401,$AZ$8:$AZ$401,BD10,$BA$8:$BA$401,"<>""")

 

[Fluff]

Not for the OP.

 

[scotthannaford1973]

thanks, Mr Fluff - worked like a dream!

 

[Fluff]

You're welcome & thanks for the feedback.