Data cleanup in Excel

Formula to identify duplicates in multiple columns

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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

0 of 45 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop