How to Use Google Sheet: How to Highlight Duplicates in GoogleSheets
Google Sheets is a powerful tool that enables users to manage and analyse data with ease. When you deal with a large data like this, one common task you have to deal with is to identify duplicate entries.
Highlighting duplicates in Google Sheets can help you to quickly identify and manage duplicate data in your spreadsheet. In this article, we will explore how to highlight duplicates in Google Sheets.
Steps on How to Highlight Duplicate Using Conditional Formatting
In this section, we will explore highlighting duplicates with conditional formatting.
Step 1: Open your Google Sheet
To begin, open the Google Sheet that contains the data you want to highlight duplicates for. If you don’t have a sheet already set up, you can create a new one by clicking on “Blank” from the main Google Sheets page.
Step 2: Select the Range
Next, select the range of cells that you want to check for duplicates. To select a range, click on the first cell and drag your mouse over the range of cells that you want to select.
Step 3: Conditional Formatting
Once you have selected the range of cells, navigate to the Format menu and select Conditional formatting. This will open a sidebar on the right-hand side of the screen.
In the Conditional formatting sidebar, select the Single colour tab. Then, from the Format cells if dropdown, select Custom formula is from the dropdown values.
In the Value or formula field, enter the following COUNTIF formula. Assuming we’re highlighting the cell range we selected earlier.
=COUNTIF(A16:C32, A16)>1
This formula counts the number of times a cell in column A16 to C32 appears in the range and highlights it if it appears more than once. This will highlight the first duplicate value.
Next, choose the colour you want to use to highlight duplicates. You can do this by clicking on the colour box next to the Formatting style dropdown and selecting the colour you want.
Finally, click on the Done button to apply the rule. The cells that contain duplicate data will now be highlighted in the colour you selected.
Conclusion
Highlighting duplicates in Google Sheets is a quick and easy way to identify duplicate data in your spreadsheet. By using the built-in Conditional formatting feature, you can easily highlight duplicates in a range of cells and quickly identify any duplicate entries.
This can save you time and help you to manage your data more effectively. With the steps outlined in this article, you can easily highlight duplicates in your own Google Sheets and improve your data management skills.
While Google Sheets allows you to manage large data like accounting, incorporating tools that can enhance accounting activities is a great way to increase productivity. PayTrack is a great fit for you. Try PayTrack and contact our technical team at peppubooks@gmail.com if you need help.
We’re starting a discord community for users who love to perform bookkeeping in a spreadsheet, you can join.
Interested in more about GoogleSheet? Check our previous articles:
