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 )