Excel - Duplicates

Question

I need to extract the same names from 4 columns. Example:&nbsp;&nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D1&nbsp; &nbsp; Arnold&nbsp; &nbsp; &nbsp; Lulu&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Benoit&nbsp; &nbsp; &nbsp; &nbsp;John2&nbsp; &nbsp; Boyd&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dennis&nbsp; &nbsp; &nbsp; Henry3&nbsp; &nbsp; Cutter&nbsp; &nbsp; &nbsp; &nbsp;Suzie&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Lafave&nbsp; &nbsp; &nbsp; &nbsp;Lily4&nbsp; &nbsp; Fleming&nbsp; &nbsp; Ruth&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Manning&nbsp; &nbsp;John5&nbsp; &nbsp; Manning&nbsp; John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Norman&nbsp; &nbsp; Henrietta6&nbsp; &nbsp; O'Sully&nbsp; &nbsp; &nbsp;Peter&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; O'Sully&nbsp; &nbsp; &nbsp; Mark&nbsp;In this simple example, only one full name comes up, it's Manning, John.&nbsp;How would I do this in Excel?&nbsp;

harun24hr · Answer

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

marie533 · Answer

Thank you for responding so quickly.I need to find the same person (ie same person registered to 2 different associations).

harun24hr · Answer

Marie533&nbsp;Use FILTER() function with XMATCH(). See the attach file.=FILTER(A1:B6,ISNUMBER(XMATCH(A1:A6&amp;B1:B6,C1:C6&amp;D1:D6,0)))&nbsp;&nbsp;

Forum Discussion

Excel - Duplicates

3 Replies

Resources