In this video, we will show you how to highlight and delete duplicates in Google Sheets.
Through conditional formatting in Google Sheets, you can apply formulas you can color code duplicate entries in the entire spreadsheet to easily spot them. Let’s say you are working on a large spread sheet, and want to quickly spot and remove duplicate entries. For that, we will be using two different options within the format drop down over here.
To start off, you need to select the column where you want to find the duplicate records in. For now, let’s select a single column and open up the format drop down menu.
From here, select the “Conditional Formatting” option. This will open up the Conditional Format Rules window.
In the “Formula Rules” section, open up the drop down menu, scroll down and select the “Custom Formula” option.
Over here, we would use the Count If formula, where we will define the range of the data and the criteria.
So, let’s start the formula with an equals to sign, followed by typing Count If.
Next, let’s enter the opening bracket followed by the range for this column.
After that, let’s enter the criteria followed by closing the brackets.
Basically, we want Google Sheets to highlight all cells where the same data is appearing more than once. Therefore, we will enter “greater than one” in the formula.
The conditional formatting counts how many times a cell text string appears in the list. If it’s more than 1, the formula returns True and those cells are being highlighted over here.
You can even highlight duplicate records in multiple columns.
For that, let’s cancel this formatting for now and select these three columns here. Now, let’s click on “Add another Rule” option here.
Like we did before, simply select the custom formula option and enter the countif formula. The only difference here would be the range. Over here, we will set the range from Column B till Column D.
You can see that the duplicate records are highlighted in all three columns.
To delete duplicate records, make sure you have selected the columns from where you want to remove duplicate entries from.
Next, open up the Data drop down menu and click on “Remove Duplicates”. From here make sure you all the columns are selected.
Simply click on “Remove Duplicates” and all duplicate entries within the selection will be removed.
That’s all!
❓💬 Would you like to know about any particular Google Sheets feature? Let us know in the comments below.
#HowTech #GoogleSheets
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here t.me/howtechtv
✅ Commercial questions info@howtech.tv
✅ Facebook facebook.com/howtechtv
✅ Instagram instagram.com/howtechprojects
✅ Twitter twitter.com/howtechprojects
- Google Sheets: How to Filter & Remove Duplicates [Using Formulas & Conditional Formatting] ( Download)
- Google Sheets - Highlight Duplicate Data in a Column or Row ( Download)
- How to find duplicates in Google Sheets ( Download)
- How to Find and Remove Duplicates in Google Sheets ( Download)
- How To Filter For Duplicates Using Conditional Formatting In Excel ( Download)
- Three EASY Ways to Find and Remove Duplicates in Excel ( Download)
- How to Remove Duplicates in Google Sheets 🧹 ( Download)
- Excel - Conditional Formatting find duplicates on two worksheets by Chris Menard ( Download)
- How to Find Duplicates in Excel & Highlight Duplicates If You Need To ( Download)
- How To: Filter Duplicate Values in Excel ( Download)
- Google Sheets - Identify Duplicates between Two Worksheets ( Download)
- Remove duplicates in Google Sheets ( Download)
- How to remove duplicates in Google Sheets ( Download)
- Remove Duplicates in Google Spreadsheet ( Download)
- How to count unique values Excel ( Download)
