How to Eliminate Records with Excel 2013’s Eliminate Duplicates Feature

Position the cell cursor in one of the cells of the data list or table.

You use the Remove Duplicates dialog box to remove duplicate records from a data list.