Hi Arvi,

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

Andy.

"Arvi Laanemets" wrote in message
...
Hi

Yesterday I found, that custom data validation is behaving very strange.
At start I tested 2 workbooks with same type of data validation on 2
different computers, than in a newly created workbook on my computer -
with same result.

I have a list of entries on sheet, and I need to restrict double entries
in a column. So I select a range (E1:E20), and apply custom data
validation rule
(COUNTIF($E:$E,$E1)<2)

1. Instead automatically being adjusted, in all cells the formula remains
same, i.e. it counts entries equal to E1, not to active cell.
2. Whatever I try to enter into any cell in range E1:E20, Excel restricts
the entry.


Thanks in advance for any good advice!

--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )