Now we’ll apply the VLOOKUP and COUNTIFfunctions together to match duplicates. You will see that some people have taken the same course. I have used some programming language course names, their IDs, and participants’ names. Method 5: Join VLOOKUP And COUNTIF Functions to Find Duplicate Matches in Excelįor this method, I have made a new dataset for this method. Read more: Excel Formula to Find Duplicates in One Column If the sum returns 2 then it will show Duplicated, If not then will show Unique. Now the final IF function will sum up the output of those two IF functions. Here IF function will show O for FALSE and 1 for TRUE for the array D5:D11. Then the IF function will show O for FALSE and 1 for TRUE for the array C5:C11. Here, the ISNA and LOOKUP functions work like the previous method. Then you will observe that it is showing “Duplicated”. If we find a match then it will show “Duplicated” otherwise “Unique”. Now we’ll use this cell reference to find the match of it in both Column C and D. That’s why I have placed the lookup value in Cell D13. In this method, we’ll use the same previous methods’ functions to match duplicates in two columns. Method 4: Find Duplicate Values in Two Columns in Excel Using IF, ISNA, VLOOKUP Functions
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |