If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

Fortunately, thanks to Excel’s FILTER() dynamic array function, creating a list of duplicate values is easier than it once was. In this article, I’ll show you how to use FILTER() to create a ...