min if
"Rene" wrote:
MIN(IF(A2:A43="d",B2:BG43)) entered as an array
[....] how do I ignore the blank cell?
You probably already discovered that the "obvious" solution does __not__
work, namely the following array formula:
=MIN(IF(AND(A2:A43="d",B2:BG43<""),B2:BG43))
But the following array formula expresses the same logic:
=MIN(IF((A2:A43="d")*(B2:BG43<""),B2:BG43))
----- original message -----
"Rene" wrote in message
...
MIN(IF(A2:A43="d",B2:BG43)) entered as an array
Does it return a 0 because of the blank cell? And how do I ignore the
blank
cell?
a2 b2 c2
d blank 120
d 100
d 150 175
a 75 90
Thanks
|