Thanks Harlan! Very interesting...

In article .com,
"Harlan Grove" wrote:

Domenic wrote...
Try...

=INDEX(A2:A10,MATCH(0,IF(A2:A10<"",COUNTIF(A2:A1 0,""&A2:A10)),0))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.
...

You could shrink that to the nonarray formula

=LOOKUP(2,1/(COUNTIF(A2:A10,""&A2:A10&"*")=0),A2:A10)