Find Duplicates based on two ranges

0

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. 

Answer
Discuss

Answers

0
Selected Answer
Please try this formula.
=IF(COUNTIFS($A:$A,$A2,$F:$F,$F2)>1,"Duplicate","")
Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login