image

Color Duplicates

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

Remove or highlight duplicates rows on Google sheet data.
It can find duplicates on single or multiple columns selected.
Generate output data on the same sheet replacing your replacing existing data or populate on a new sheet.
Sort your output data so that all duplicates rows comes together. Get It Free For 7 days

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.

Screenshots

image
image
Back to Top