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
Bookmarks