Find First Nonblank Cell

[mikechambers]

Is there a function that will find the first nonblank cell in an array, like returning the cell address or position in the array?

 

[mikechambers]

Figured it out.

{=MATCH(TRUE,L19:L50<>"",0)}

That at leat returns the position.

 

[Richard Schollar]

Hi Mike

If the blank cells are genuinely blank (ie don't contain formulas returning "") and the other cells contain text (not numerics) then you could use:

=MATCH("*",L19:L50,0)

instead, which doesn't have to be array entered.