Excel - Duplicates

New Contributor

I need to extract the same names from 4 columns. Example:

 

      A               B                C               D

1    Arnold      Lulu           Benoit       John

2    Boyd         John          Dennis      Henry

3    Cutter       Suzie         Lafave       Lily

4    Fleming    Ruth          Manning   John

5    Manning  John          Norman    Henrietta

6    O'Sully     Peter          O'Sully      Mark

 

In this simple example, only one full name comes up, it's Manning, John.

 

How would I do this in Excel?

 

3 Replies

@Marie533 

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

Thank you for responding so quickly.

I need to find the same person (ie same person registered to 2 different associations).

@Marie533 

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

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

 

Harun24HR_0-1659497365542.png