Open the Excel worksheet and select the range of cells that you want to search for duplicate items. For example, you might want to click a column header to select a column of telephone numbers.

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.