No duplicates with text limit values

[RichardO]

I'm trying to enter a formula for data validation.

I went to Data - >Validation, selected custom and put this formula:

AND (LEN($E:$E) <= 10,COUNT($E:$E,E1)<=1)

This is not working for me. I'm trying to validate that the text is not more
than 10 characters and that it is unique for the column E. Any ideasy

 

[Frank Kabel]

Hi
try:
AND(LEN(E1)<=10,COUNTIF($E:$E,E1)<=1)

 

[Frank Kabel]

Hi
- simply select your cells !:E100
- goto 'Data - Valdiation
- choose 'Custom' and enter this formula

 

[Frank Kabel]

Hi
whyt formula did you enter?

 

[RichardO]

AND(LEN(E1)<=10,COUNTIF($E:$E,E1)<=1)

Hi
whyt formula did you enter?

 

[Frank Kabel]

And you have entered this formula for the data validation of cell E1?