R
Rene
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
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