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

OLD	NEW	Result
xyz@bbec.com
abc@gmaa.com|cde@dca.com	mam@ma.com|da@da.com|ee@ee.com|cde@dca.com	mam@ma.com|da@da.com|ee@ee.com|
123@outlk.com	123@outlk.com

<tbody>
</tbody>

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