scotthannaford1973
Board Regular
- Joined
- Sep 27, 2017
- Messages
- 114
- Office Version
- 2010
- Platform
- Windows
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))
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))