Highlight Duplicates in Google Sheets (using Easy Formulas)

Published: 12 January 2021
on channel: Spreadsheet Point

141,293

478

Article Link: https://spreadsheetpoint.com/highligh...

In this video, I will show you how to highlight duplicates in Google Sheets.

While there is an inbuilt functionality to remove duplicates in Google Sheets, there is nothing inbuilt to highlight these duplicates.

But you can easily do this using a combination of formula and conditional formatting.

The following scenarios are covered in this video:

00:00 Intro
00:15 Highlight Duplicates in a single column
02:37 Highlight only the duplicate instance
05:00 Highlight duplicates in multiple columns
06:49 Highlight duplicate rows (duplicate records)

You can also read about this here: https://spreadsheetpoint.com/highligh...

Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - / spreadsheetpoint

This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets

You can also find a lot of useful resources on Google Sheets here: https://spreadsheetpoint.com/

#GoogleSheets #GoogleSheetsTips #Spreadsheet