Remove emails from sheet1 through another sheet2

[satish78]

I want to remove emails from sheet1 of emails in sheet2

Example

Sheet1 ColumnE1
sridhar.java@gmail.com;ashish.j2ee@gmail.com
james.santa@yahoo.com
pavan@hotmail.com;naga.sara@gmail.com

Sheet2 ColumnA
ashishj2ee@gmail.com
naga.sara@gmail.com

I want to remove or unsubscribe Sheet2 ColumnA emails from sheet1 columnE1
Need excel formula. Please help me in this.

 

[saeedkk]

Hello,

well you can use =SUBSTITUTE function with an empty string , but you have the issue you would need to go for each email you have in sheet 2 Col A an extra column in order to filter this email from all the emails in sheet1 Col E1

=SUBSTITUTE(E1,Sheet2!A1,"")

so this way you would have the email filtered from all the emails in sheet 1 Col E ... then you filter the second email from the result you just had and gradually you move along ...

if you have a lot of emails to filter we would need to go to VB

waiting your reply if this is enough for you

Hope this helps
regards
saeed khodor