Forum Discussion

Marie533's avatar
Marie533
Copper Contributor
Aug 03, 2022

Excel - Duplicates

I need to extract the same names from 4 columns. Example:         A               B                C               D 1    Arnold      Lulu           Benoit       John 2    Boyd         John      ...
excel
Formulas and Functions
Harun24HR's avatar
Harun24HR
Bronze Contributor
Aug 03, 2022

Marie533 

How you consider/detect only Manning, John is full name? Why not Boyd John or Benoit John?

  • Marie533's avatar
    Marie533
    Copper Contributor
    Aug 03, 2022
    Thank you for responding so quickly.

    I need to find the same person (ie same person registered to 2 different associations).
    • Harun24HR's avatar
      Harun24HR
      Bronze Contributor
      Aug 03, 2022

      Marie533 

      Use FILTER() function with XMATCH(). See the attach file.

      =FILTER(A1:B6,ISNUMBER(XMATCH(A1:A6&B1:B6,C1:C6&D1:D6,0)))

       

       

Resources