Youtor
Highlight Duplicate Values in Two Columns Excel Formula
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=AIT3qktY3zg
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 - • Excel SUMPRODUCT Function - A Guide t... • Sum every nth row in a list - • Sum Every Nth Row in Excel • 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 • Connect with us! • LinkedIn ► / 18737946 • Instagram ► / computergaga1 • Twitter ► / computergaga1
#############################
