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.

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.

By Jake

Jake blog's many places on a variety of topics, including travel, tech, baseball, and writing. You can read more of his technology articles on Delighted Robot. Jake occasionally posts about great food at Daily Munch.

Exit mobile version