Forum Discussion
How to identify/highlight reverse cell combination from a list
Hi All, I'm trying to identify/highlight cell combination that are reversed from a list. In this example, in column A I have a list of first names, in B a list of last names. This is what the rep...
=COUNTIFS($A$2:A2,$B2,$B$2:B2,$A2)Perhaps you don't have to concatenate the serial numbers with this rule for conditional formatting.
=$A$2:$B$18This is the range the format applies to in the example.