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.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.