Why do you want to find the address (btw look at the ADDRESS function)?
If you want the value just use INDEX and MATCH



--
Regards,

Peo Sjoblom



"Mike" wrote in message
...
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?