Browse » Home
Thursday, May 12, 2011
How to Eliminate Duplicate Records in Excel
1. Open the Excel spreadsheet.
2. In the 'Data' tab, choose the 'Advanced' button in the group marked 'Sort Filter.' (In Excel 2003, click 'Data,' then 'Filter,' then 'Advanced Filter.')
3. Confirm that your data range--all the rows you want to filter--is noted in the dialog box that appears. If it isn't, simply click in the first cell of the range (the dialog box will shrink to the cell selection field temporarily) and drag the mouse cursor down to select. When you release the button, the dialog box will restore.
4. Eliminate duplicate entries by clicking on the 'Data' tab, then clicking the 'Advanced' button in the 'Filter' button set. Excel should automatically select your entire data set, but if it doesn't you can select it yourself by clicking and selecting the range.
5. Leave the radio button next to 'Filter the list, in place' filled, and place a check mark next to 'Unique records only.' Click 'OK.' Excel will delete any duplicate entries seamlessly, without leaving blank rows.