How can we find duplicate values across multiple columns? For this task, we’ll use two Excel helper formulas: One to concatenate the columns you’re comparing; a second to count the duplicates.

Filters are great tools, but you can't remove specific items from the results. When you need to do this, try Find All in Excel instead.