How to Avoid Duplicates in Column in Google Sheet?

Follow below steps to avoid duplicates in Column in google sheets

  1. Select column in which you wish to avoid the duplicates
  2. Go the Data -> Validation
  3. In Criteria select Custom Formula is and put the formula =COUNTIF(B:B, B1)=1 (where B is the column and B1 is the start of the column after which we have to check for duplicates)

If you copy the duplicate value in the column it will highlight in red as below

If you enter duplicate value it will give error popup as below

Leave a Reply

Your email address will not be published. Required fields are marked *