Well, the match part I just figured out. That just returns the position in
the array. I'll have to do some extra work to turn that into an address.

Thanks.

"Teethless mama" wrote:

="A"&MATCH(TRUE,A1:A10<"",0)

ctrl+shift+enter, not just enter


"Mike" wrote:

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