👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you! 👍👍
Download the featured file here: https://docs.google.com/spreadsheets/d/1fnQDj3xaO6rmftISCKAzmwXRCQTU5sXaLCzpohe0IvA/edit#gid=0
In this video I demonstrate how to highlight duplicates in Google Sheets. This type of conditional formatting requires a formula. The functions used in this video are COUNTIF, MATCH and ARRAYFORMULA.
Table of Contents:
00:00 - Introduction
00:13 - Highlight duplicates in a single column
03:06 - Highlight duplicates but ignore first occurrence
05:08 - Highlight duplicates across multiple rows & columns - 2D range
06:17 - Highlight duplicates across separate columns to find matches and differences
08:05 - Highlight duplicates if entire record or row matches
------------------------
