G. Roderick Singleton wrote:


Isn't the empty string really a NULL? If yes, then wouldn't 0x0 be a
better criteria?



No, that gives an error. I looked for a NULL() function but no dice.

It seems to me that the COUNTIF() function is broken in 2.x (I forgot to mention that fact in my previous post, sorry).

For example, if cell A1 contains "S1"

=countif(A1;"S1")

gives 1

= countif(A1;".*")

gives 0

Looks like the RE parser is broken. -(

L

Reply via email to