Microsoft office Excel Tips – Use Conditional Formatting To Find Duplicate Data – Office Setup

There may be many reasons to look for and eliminate duplicate data in Excel. If you use Excel as lots of people do for managing lists or tables of data you may manage a list of customers, employees or an inventory then duplicate records need to be eliminated. Also as a database grows duplicate entries can be a problem, which in themselves can cause issues for data quality and analysis.