How to Remove Duplicates That Are Case Sensitive in Excel 2007. By definition, Microsoft Excel 2007 considers a duplicate to be a row of data that matches another row in your worksheet exactly.

How to remove duplicates in Excel for a single column When you have duplicate data that you want to remove from a single column in your dataset, start by clicking into the column you want to dedupe.