How to highlight duplicate content on Google Sheets

While working with the data table, it is common for you to reformat the table and it should be done before saving the complete version. With many statistics tables, there will be some lines, or columns of the same content.

If the table has little content, we can search manually to delete them. However, with multiple tables, this approach is not feasible. Previously, Network Administrator once instructed you to read how to delete duplicate data on Excel by Remove Duplicate, or mark duplicate data to identify. And in the article below, you will know how to mark, identify duplicate data on Google Sheets.

This is an example data table that marks the same data on Google Sheets.

How to highlight duplicate content on Google Sheets Picture 1

Step 1:

At the table interface, we black out the area you want to identify duplicate data. Then click on the Format item above and then select Conditional Formattting , conditional data format.

How to highlight duplicate content on Google Sheets Picture 2

Step 2:

Immediately on the right of the interface appears the Conditional format rules column for the user to set the conditions for the data. In the Apply to range section , the column data area that we have highlighted above will be automatically added.

How to highlight duplicate content on Google Sheets Picture 3

Step 3:

Next down to Format cells if change the value to Custom formula is in the drop-down menu list. Then frame Value of fomula and we'll enter the formula like below.

= countif (B: B, B1)> 1

Because the data I want to classify and mark the same is in column B, the condition will be the same. The data is in another column and we will change the column position.

How to highlight duplicate content on Google Sheets Picture 4

Step 4:

Go to the Formatting style section, select the color to mark the duplicate data. Click the paint bucket icon and select the marker color. Finally, click Done at the bottom to complete the settings above.

How to highlight duplicate content on Google Sheets Picture 5

As a result, the data table will identify and classify the lines with the same content, through the markup colors that the user has set up above. Your job now is to edit or delete duplicate data in the statistics table.

How to highlight duplicate content on Google Sheets Picture 6

A simple operation and quite necessary when we handle statistics tables on Google Sheets. Unlike Excel when you have the option to delete the same data, with Google Sheets we will mark the same data to choose to delete or edit if the request.

I wish you all success!