Formula to identify duplicates in multiple columns

One of the benefits of using the Remove Duplicates tool is that it can be used to look across multiple columns and find the duplicates where multiple columns are the same.

You can achieve the same thing with a formula. By combining the COUNTIF with a CONCATENATE formula you can easily compare across multiple columns

Back to: