Column “C” contains the authors and their affiliations for each paper (462 papers). The authors(s) for each affiliated organization are included within brackets just before the name of the organization.

Column A contains the last names of all authors of all organizations participated in publishing the 462 papers listed in Column C

Please see attached file.

The question:
I need to identify those authors listed in column “A” that are affiliated with “King Saud Univ” per column “C”.
Maybe by indicating True or False in Column "B" next to each author.

Is there any formula to do such job?. I have large number of files with similar job.

Help will be greatly appreciated.
Taisir