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.
Click here to download the featured file.
Video 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
