Google SheetsOtherOthers

How to Avoid Duplicates in Column in Google Sheet?

Google Sheets Image

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

About author

Love coding, crazy about logic, like solution architecting and solving problems. Thirsty for knowledge, challenges & most importantly innovation. One of the passionate brain behind SpryOX

Leave a Reply

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