Highlight Duplicate Values in Two Columns - Excel Formula

Highlight duplicate values in two columns using Conditional Formatting and the SUMPRODUCT Function. In this video tutorial, we highlight the duplicate rows in a list based on two columns. The values in these two columns must both be the same for our formula to identify them as a duplicate. This task is accomplished using the incredible SUMPRODUCT function and COUNTIF. Find out more about SUMPRODUCT using the links below. A guide to the SUMPRODUCT function - https://youtu.be/Lc52EQrztcc Sum every nth row in a list - https://youtu.be/C62Wq5d0DM0 The exact formula used in this video tutorial is shown below. You can copy this and adapt the criteria for your own needs. This formula can also easily be changed to handle duplicates dependent on more than two columns if needed. Enter the greater than symbol before the two 1's in the formula. I am not allowed to enter these in a video description. =SUMPRODUCT((COUNTIF($A$2:$A$9,$A2)1)*(COUNTIF($B$2:$B$9,$B2)1))=1 Want to seriously improve your Excel skills? Check out the online course - https://bit.ly/UltimateExcel Find more great free tutorials at; https://www.computergaga.com