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

When it comes to working with data, whether it's a basic list of entries or a large dataset, Excel is usually one of the go-to tools for most people, and for good reasons. First off, it allows you to ...

Use implicit And and Or operators with Excel’s Advanced Filter feature to create complex, but powerful, filtering combos. Editor’s Note: This article was originally published in July 2010 and the ...