Sunday, April 8, 2012

yogi_Filter An Array Of Comma Separated Values To Exclude A Specified String

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #497    Apr 8, 2012

my Circle mate Robert Baker said at Google+ 
Hi Yogi, 
I have another column of data I want to filter. This column is made up of comma separated email addresses. The principle domain is written in B1. I want to find all rows in column A that have an address that is not from the principle domain and I wish to list those addresses in column C. Where Cell A,n has only principle domain addresses The corresponding Cell C,n should be blank. 
Here is some sample data 
in the following proposed solution, I have masked the essential character needed in an email address with another string