Back to Browse

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

137.0K views
May 31, 2023
5:55

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

Download

1 formats

Video Formats

360pmp410.0 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

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