Download the featured file here: [ Ссылка ]

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
------------------------

свернуть