Duplicates in a cell

Hi everyone,

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
and
Column 2: A, B, D

Then A and B are duplicates?

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.