Ignore Blank Cells in MINIMUM array formula

I would like the following array formula to ignore blank cells when calculating the minimum value.

{=MIN(IF($BQ$11:$BQ$1011>=$CA11,IF($BR$11:$BR$1011<=$CB11,$BU$11:$BU$1011)))}

Column BQ contains start distance of data
Column CA contains start distance that I want to look for (in this case 0)
Column BR contains end distance of data
Column CB contains end distance I want to look for (in this case 20)
Column BU contains heights (the actual data I want to find the minimum value of)

Can you please tell me how to ignore blank cells in the array formula

Thanks

{min(if($bq$11:$bq$1011>=$ca11,if($br$11:$br$1011<=$cb11,if($bu$11:$bu$1011>0,$bu$11:$bu$1011,9^9))))}
try this array formula

Try this array formula,

Please Login or Register  to view this content.

Hi

The IFERROR formula does ignore the blank cells but does NOT include 0 as a minimum value. Can you please make the formula so that it ignores blank cells (cells with no numbers in them) but includes 0 as a minimum value.

I was thinking perhaps that the something like the following could be somehow included in the formula to ignore the blank cells

(BR$11:BR$1011<>"")

Thanks

In other words when the column BU contains a 0.0, I want the formula to return 0.0

That works Thanks