Sometimes when we perform data entry task, or copying data from somewhere, we occasionally encounter the issue where some data are duplicate. Unfortunately, In Excel, dealing work duplicate records aren’t that difficult.

In this tutorial, I will show you 3 ways of my prefer methods – Conditional Formatting, COUNTIF, Remove Duplicates – dealing with duplicate data in Excel.