Forum Discussion
Solved
Comparing Duplicates in Column A with Duplicates in Column B
Hello! I'm hoping there's a way to do this but I haven't figured it out yet so any help would be greatly appreciated. I have two columns of data which have duplicate values in: Fruit Quanti...
I solved it using the following formula:
=AND(COUNTIFS($A$2:$A$11,A2,$B$2:$B$11,B2)>1,C2="Primary")Thanks for the help everyone!
I understand you want to identify fruits which have only duplicates, like "Apples" and "10" in your example. Enter formula in D1 and copy down:
=COUNTIF($A$1:$A$8,A1)=COUNTIFS($A$1:$A$8,A1,$B$1:$B$8,B1)
Please compare / check solution in attached file.