Skip to main content

Duplicates in a cell

  • April 22, 2020
  • 0 replies
  • 4 views

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?