Site icon The Learning Zone

Compare Two Excel Worksheets & Find Duplicates Using Formula or Conditional Formatting

Compare Two Excel Worksheets & Find Duplicates Using Formula or Conditional Formatting
YouTube video player

Microsoft Excel Tips and Tricks

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.

Credit Chester Tugwell

Exit mobile version