Excel - De-Duplicating Data

Stripping Out Duplicate Data From an Excel Worksheet

We often find that after converging data from a number of sources we have duplicate records in our worksheets. In this article I show you how to strip out those duplicate rows using the Excel “Remove Duplicates” option.

De-duplicating A Single Excel Column

In the following example we have duplicate company names in the data on our worksheet.