Forum Discussion
Opposite duplicate column
Is there a formula that can highlight duplicate teams? Here is the situation. I asked for everyone to submit teams. I noticed that some employee #2 was already submitted by employee #1. How would...
One approach is to identify the duplicate teams with conditional formatting. Since conditional formatting is a legacy feature (and doesn't play well with arrays), we must keep it simple:
Conditional formatting formula:
=COUNTIFS(Employee_1,$F2,Employee_2,$G2)+COUNTIFS(Employee_2,$F2,Employee_1,$G2)>1