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.

Cutting and pasting ranges of cells is a common operation in Excel, and Microsoft's Visual Basic offers streamlined functionality to easily automate the process.