CODEWITHSUNDEEP
excel
Heather
Heather

Reputation: 7

How to find the first cell with a specific value in each row?

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.

Using the above example, I want to find the lowest level manager who is certified for each employee. That is, ColumnF results as shown under the header:

enter image description here

Upvotes: 1

Views: 2211

Answers (1)

A.S.H
A.S.H

Reputation: 29332

Function findCertified(row As Integer)
    findCertified = Sheet1.Rows(row).Find("(Certified)").Value
End Function

Upvotes: 1

Related Questions