> =23-MATCH(0,A1:A23,0)

I like it! Thanks. :>)
Another advantage your equation has is that it returns an error (#N/A) if
there are no zero's.
Thanks. :>)
--
Dana DeLouis

"daddylonglegs" <daddylonglegs.27gqwm_1147048801.1232@excelforum-nospam.com>
wrote in message
news:daddylonglegs.27gqwm_1147048801.1232@excelforum-nospam.com...
>
> ..or just
>
> =23-MATCH(0,A1:A23,0)
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile:
> http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=539700
>