Formula to identify duplicates in multiple columns

Please sign up for the course before starting the lesson.

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: Data cleanup in Excel > Identify and Remove duplicates in Excel