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" <domenic22@sympatico.ca> wrote in message
news:domenic22-923989.12453407072006@msnews.microsoft.com...
> Try...
>
> =COUNTBLANK(INDEX(A2:A10,MATCH(BigNum,A2:A10)+1):A10)
>
> ...where BigNum is defined as 9.99999999999999E+307.
>
> Hope this helps!
>
> In article <geoff1234.2al1yn_1152288602.6704@excelforum-nospam.com>,
> geoff1234 <geoff1234.2al1yn_1152288602.6704@excelforum-nospam.com>
> 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?