Color Duplicates

Google sheet addon which highlight or removes duplicates data on Google sheet

YouTube video how to use it

How to use Color Duplicates Addon

  • It select the used range on the sheet itself when open the sidebar.
  • Or you can manually select the range on the sheet and click on the table icon in sidebar
  • Select single column or multiple columns here on the basis of which duplicates needs to be removed or colored.
  • All columns are selected by default.
  • This where you can select whether you want to remove duplicate rows from your data or just want to see duplicate entries highlighted.
  • You can select a color to get your output data colored and formatted on the output generated.
  • You can turn on/off the sort data option
  • Select a column here on which data to be sorted
  • Select here if the output should replace the existing data or generate output on a sheet.