In our example ISBLANK(Range) creates the following array. MATCH(FALSE,{TRUE;TRUE;TRUE;FALSE;FALSE;FALSE;FALSE},0) then looks for the first exact match to a FALSE value within this array. This returns the value 4 since the first FALSE value is in the 4th position and this is our first non blank cell is in the range.

How To Find The Position Of The First Non Blank Cell In A Range - 85