Sumproduct-Function

Sumproduct function is used to find duplicates across all columns in Excel. It can multiplies ranges or arrays together and returns the sum of products.