Longer but addresses all but truly blank
=IF(ISNA(MATCH(99999,N:N)),MATCH("zzzzzz",N:N),MAT CH(99999,N:N))

--
Don Guillett
SalesAid Software

"Domenic" wrote in message
...
Interesting...but the drawback with this is that there needs to be at
least one cell containing a numerical value and another one containing a
text value. Otherwise, you get a #N/A. :)

In article ,
"Don Guillett" wrote:

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)