Counting number of blank cells until value found in cell

[Jack Nutt]

How do I set up a cell for a range of cells to count the number of
blank cells until a value shows up in one of the cells. I am looking
for the number of blank cells before a cell shows up with a value in
it.

Thanks

 

[Frank Kabel]

Hi Jack
if your cell range starts in row one try the following array entered
formula (entered with CTRL+SHIFT+ENTER)
=MIN(IF(A1:A1000<>"",ROW(A1:A1000),10000))-1