Excel2000: Data validation behaving funny

A

Arvi Laanemets

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation help 5
2007 data validation not working 1
Data Validation quaestion 2
Formula to validate characters within a string of data in aparticular cell 1
Data validation on data validation function 1
Data Validation 4
Populate Data from Summary Sheet 5
Data validation error with multiple CPU 3

Top