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 ...

For multiple columns, select the relevant columns, use the “Remove Duplicates” feature, and specify columns to consider for duplicates.