I am hoping someone can help me. I have to create a document that includes multiple segments under some columns (over 20 in some cases). I want to make sure I avoid duplicates between those columns.
Is there a formula that can look into both columns and figure out if:
Column 1 : A, B, C
Column 2: A, B, D
Then A and B are duplicates?