Color Duplicates Google sheet add-on that highlights or removes duplicate data from Google Sheet. It can find duplicates on single or multiple selected columns. Removes or highlights duplicate rows or columns from Google Sheet. Generates output data on the same sheet replacing your existing data or populating on a new sheet. Sorts your output data so that all duplicate rows can come together. get it free Color Duplicates Addon Step 1 : Select the range with your table Step 2 : Select Columns Step 3 : Select Options Step 4 : Sort Data Step 5 : Place Data In? Screenshots Previous Next