Column “B” 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 the 462 papers listed in Column B
Please see attached file
The question:
I need to identify those authors in column “A” that are affiliated with “King Saud Univ” per column “B”. Maybe by indicating True in column "C" in the same row that match the author affiliated with "King Saud Univ"
Is there any formula to do such job?. I have large number of files with similar job.
Help will be greatly appreciated.
Taisir
Column A contains the last names of all authors of the 462 papers listed in Column B
Please see attached file
The question:
I need to identify those authors in column “A” that are affiliated with “King Saud Univ” per column “B”. Maybe by indicating True in column "C" in the same row that match the author affiliated with "King Saud Univ"
Is there any formula to do such job?. I have large number of files with similar job.
Help will be greatly appreciated.
Taisir