I am following some tutorials and discussion on forcing uniqueness in Google Sheet Column (I need it for ID indexing). I have been using Data Validation for some time, but i have a problem with custom formula and using some functions. I know that that i should use

=COUNTIF($A:$A,"="&A1)  < 2



But if I enter it to custom formula input box I am pressing "save" button and nothing is happening. It seems like google is stopping me from entering this formula. For other formulas I can save the validation and it is working. Problem is that I don't get any feedback(error) from Google, what is wrong in my formula.

1 Answer 1


Try to input this formula instead of yours. Maybe is just your locale settings that prevents you from using the formula. Try semicolon instead of comma:

=COUNTIF($A:$A; A1)<2 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.