Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/01/Highlight-and-Count-Duplicate-Rows.xlsx

In this Microsoft Excel video tutorial I demonstrate how to highlight and count duplicate rows in your data. This can include or exclude the first occurrence.

Table of Contents:

00:00 - Introduction
00:03 - Concatenate the values in each row
01:02 - Count the number of occurrences of each row
01:54 - Highlight duplicate rows with conditional formatting
02:54 - Don't highlight or count the first occurrence of a row
04:33 - House your data in an Excel table
------------------------