Not allow entering repeated references in a column - HOW?

  • Thread starter Thread starter ritinha
  • Start date Start date
R

ritinha

Sorry Frank,
But I made a mistake when posting the formula.
I´ve used the formula that you´ve mentioned, i.e.:
=COUNTIF($A$1:$A$25,A1)=1 ... & does not work :confused:
Did you try it? Does it work with you?
Thanks and sorry again,
Ritinh
 
Hi
- what cells have you selected BEFORE entering this formula in the data
validation dialog
- what values have you entered in A1:A25
 
Back
Top