You may even like this better. Add 9's and z's if you like
=MAX(MATCH({9.999E+307,"zzzz"},$A:$A))


--
Don Guillett
SalesAid Software

"Domenic" wrote in message
...
I like this one. Definitely more efficient than the one I offered.
I'll have to remember it. :)

In article ,
Aladin Akyurek wrote:

E2;

=MATCH(9.99999999999999E+307,A:A)

E3:

=MATCH(REPT("z",255),A:A)

E4:

=IF(COUNT(E2:E3)=2,MAX(E2:E3),SUMIF(E2:E3,"<#N/A"))

The following would define a dynamic range in A on Sheet1:

=Sheet1!$A$1:INDEX(Sheet1!$A:$A,E4)