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
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