How to Find duplicate emails in Google Spreadsheet which are followed by ";" in some cells

[satish78]

Hi Guys,

I would like to find duplicate emails from sheet2 ColumnA in Sheet1 ColumnH
In Sheet1 sometimes in a cell there are multiple emails followed by ";"
Need a excel formula to find duplicate entries in Sheet1 were I need duplicate entry results in sheet2 columnB in "TRUE" or "FALSE"

Below is sample worksheet which I have.

https://drive.google.com/file/d/0B65hREJXscJURmhaeThMdTNFamc/view?usp=sharing

 

[hiker95]

satish78,

When I attempted to download your workbook, my PC's Security Package, Webroot SecureAnywhere, returned the following message:

This website has been reported as unsafe

https://docs.google.com/uc?id=0B65hREJXscJURmhaeThMdTNFamc&export=downl...

We recommend that you don't continue to this website because it is reported to contain the following threats:

Phishing threat:

This site might try to trick you into disclosing your login, password or other sensitive information by disguising itself as another website you may trust.


Here is a free site you can post your workbook to:

You can upload your workbook to (the BLUE link-->) Box Net ,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.