Saturday, February 14, 2009

Excel - Removing duplicate values


We can remove duplicate entries in a list using MS-Excel.

Click Data->Filter->Advanced Filter in the Excel sheet.

Check the 'Unique records only' checkbox in Advanced filter Dialog box, to remove the duplicate entries in the list.
More Articles...

1 comment:

Ashley said...

By using the advance filter we can easily remove the duplicate contents. Otherwise use a dedupe software for excel. It will find and remove the duplicate values.

Search This Blog