Suppose you want to validate column AAdd to A1 the validation:Allow: CustomFormula: =countif(A:A,A1)<=1Click OKNow select the whole column A, go to Data -> Validation and click "Yes" when asked if you want to expand validation to all the cells in the range.