How to dedupe an Excel List

"How can I dedupe a list of information in Excel to display only unique data?"

The best way to delete duplicate entries from an Excel spreadsheet is to use the Advanced Filter. This feature is located on the Data tab in all recent versions of Microsoft Excel and makes it a snap to remove any duplicate data you might have in your spreadsheet workbook.

To remove duplicate entries from your spreadsheet, start by clicking the Advanced Filter button on the Data tab.

Delete duplicate rows in Excel with Advanced Filter

Choose the data on your spreadsheet you want to sort by setting a list range. You can either filter the list on your current worksheet in the current row, or copy the list to another location. Check the box to display Unique Records only to eliminate duplicate entires. Click OK and your list will be filtered to display on records which are unique.

Configure Excel Advanced Filter settings