Similar Words in two Columns alligned per wor

 

ie I need a formula that will identify cooomon words between 2 columns but with the Same Row.

 

ie Say A1 to be Compare to B1

        A2 to  be compared to B2 ect

My Data is as follows

 

  A B
1 CRONJE T CRONJE TINA-MARI
2 DE SWARDT JB SWARDT JOHAN BAREND DE,SWARDT CHRISTEL DE
3 SQUARES TRUST SQUARES TRUST
4 NTLAI EM NTLAI MOTSELENG EDWARD,NTLAI THENJIWE ROSEMARY
5 NDABANA BXL MAGWENTSHU BULELWA XOLISWA LORRAINE,NDABANA LUNGA MBASA
6 SCORRANO E JANSEN ELIZABETH

 

 

 

SCORRANO E

JANSEN ELIZABETH

 

 

 

By: Xavier

Leave a Reply

Your email address will not be published. Required fields are marked *