What formula could I use to find a duplicate based on two criteria matches.
I need a match on Column A (Worktype) and Column F (Policy Number) and to find any duplicates that match those two criteria.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Find Duplicates based on two ranges
0
Answers
0
Selected Answer
Please try this formula.
=IF(COUNTIFS($A:$A,$A2,$F:$F,$F2)>1,"Duplicate","")