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