I have a table where column A and B are a pair: if Column A has data, Column B should too, and vice versa. How could I flag rows where this is not occurring?
I tried
=OR(AND(A1<>"", B1=""), AND(B1<>"", A1=""))
You may try:
=counta($A1:$B1)=1