When you deleted the data did you use a space or something?
a lot of functions treat a space as an entry.


i would recomend rather than Counta
Counta counts functions concluding ""

=if(countblank(A1:A5)=0,"true","false")


"andrewm" wrote:

>
> thanks,
>
> tried counta - started with false when no cells had names, changed to
> true when all cells had an entry, but when I deleted a cells contents
> the counta result stayed with true - any ideas
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=377637
>
>