Strange that excel didn't/wouldn't kick up a formula error message.

Biff

<Andy wrote in message ...
It's nice to be able to help you, for once, rather than the other way
round!

Andy.

"Arvi Laanemets" wrote in message
...
Oops!

Thanks!
Arvi Laanemets


<Andy wrote in message ...
Hi Arvi,

Are you using
COUNTIF($E:$E,$E1)<2
or
=COUNTIF($E:$E,$E1)<2

Andy.