Google sheet addon which highlight or removes duplicates data on Google sheet
How to use Color Duplicates Addon
Step 1: Select the range with your table
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
Step 2: Select Columns
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.
Step 3: Select Options
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.
Step 4: Sort Data
You can turn on/off the sort data option
Select a column here on which data to be sorted
Step 5: Place Data In?
Select here if the output should replace the existing data or generate output on a sheet.