Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/05/Find-duplicates-across-worksheets.xlsx

In this Microsoft Excel video tutorial I explain how to compare two worksheets and identify duplicates; I demonstrate two methods. The first method uses the COUNTIF function and the second method uses conditional formatting.

00:00 Introduction
00:44 Method 1 - Formula
03:21 Method 2 Conditional Formatting