Duplicates in a cell

310 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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

Then A and B are duplicates?

0 Replies 0