When working with large volumes of data in Google Sheets, many a time, you come across the issue of duplicate data. The duplicate data reduces the quality and accuracy of various performance metrics, decision-making, and mission-critical efforts. That’s why you need to find a formula to highlight duplicates in Google sheets so that you can easily remove them and get reliable spreadsheets ready in your hand.
Here’s a guide to highlighting duplicates in a single column –
To highlight Duplicates in a single column, you need to follow the following steps –
- Open your spreadsheets and select a column.
- For example, select column C > Format > Conditional formatting. Open the drop-down list under format rules, and then select Custom formula is
- Put the value for the custom formula, =count if (C1:C, C1)>1.
- Find Formatting styles under Format rules to set a different color for highlighted duplicates. You must click on the Fill color icon and select your desired shade.
- Finally, hit Done to get the duplicates highlighted in a single column.
- Similarly, if you have to do the same for column A, the formula becomes =count if (A1: A, A1)>1.
Since the accuracy of your spreadsheet data hugely impacts your reporting, analysis, metrics, and decision-making, you seriously need to apply formulas to highlight duplicates in Google Sheets. You should reach out to Coefficient to automatically access real-time, supreme quality data from your various business systems to google sheets. The solution allows you to easily import, export, and sync data from various business data warehouses to Google Sheets.