In your sheet, click Extensions, then Remove Duplicates, and choose: Find Duplicates or Uniques. Follow the steps in the add-on wizard to choose the range and columns you'd like to check for ...