Compare Columns and Delete Emails from a ROW

[Blessy Clara]

Hi I have an excel sheet with two columns
Column 1 - is OLD
Column 2 - is NEW

I would like to compare the NEW email with emails in OLD column, and if it found in OLD data then remove it in New column

Example as this [TABLE="width: 500"]
<tbody>[TR]
[TD]OLD[/TD]
[TD]NEW[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]xyz@bbec.com[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]abc@gmaa.com|cde@dca.com[/TD]
[TD]mam@ma.com|da@da.com|ee@ee.com|cde@dca.com[/TD]
[TD]mam@ma.com|da@da.com|ee@ee.com|[/TD]
[/TR]
[TR]
[TD]123@outlk.com[/TD]
[TD]123@outlk.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance
Email formats have been mimicked to avoid privacy issues

 

[Fluff]

How about

Function BlessyClara(St1 As String, st2 As String) As String
   Dim Sp As Variant
   Dim i As Long
   Sp = Split(St1, "|")
   BlessyClara = "|" & st2
   For i = 0 To UBound(Sp)
      BlessyClara = Replace(BlessyClara, "|" & Sp(i), "")
   Next i
   BlessyClara = Replace(BlessyClara, "|", "", 1, 1)
End Function

Used like
=BlessyClara(A2,B2)

 

[Blessy Clara]

Hi Fluff,

Thank you very much for your time and the solution. Yup, awesome

 

[Fluff]

Glad to help & thanks for the feedback