how do not allow a number to be repeated on the same column?

[christine Helou]

I want to not allow the entry of a number more tan once on the same colunm

 

[Teethless mama]

Select your data range then go to:

Data > Validation > Settings > Allow: select Custom > Formula:
=COUNTIF($A$1:A1,A1)=1