Hey Domenic,

What's your take on 99^99 ?

Any opinions or foreseeable problems?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Domenic" wrote in message
...
Try...

=COUNTBLANK(INDEX(A2:A10,MATCH(BigNum,A2:A10)+1):A 10)

...where BigNum is defined as 9.99999999999999E+307.

Hope this helps!

In article ,
geoff1234
wrote:

Hi again,

I've got a list like this:

45
32
23
blank
34
45
blank
blank
blank

any idea how to count the number of blanks after the final non-blank
cell?