If you have two similar Excel spreadsheets, or different versions of the same original spreadsheet, it can be useful to compare the Excel files and see how they differ.

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.

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.