This method might remove duplicates in your data that you'd like to keep, so if this happens, consider manually deleting the data cell by cell.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.