如何在每一行中找到第一个具有特定值的单元格?

I am looking for a formula or macro that will return the first cell in which a specified value occurs by row. For example, Column A would be EMPLOYEE NAME, Column B would be MANAGER LEVEL 1, Column C would be MANAGER LEVEL 2.... so on. Some managers are certified, which will be indicated by their name - Brian (Certified) or Brian if not certified. I am looking for a formula or macro that will r