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 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!