The problem that I am trying to solve:
1. Each work code that have specific [types] assigned to it.
2. The work codes also have specific [owners] associated with it as well
Now I want as formula in column D that does this;
• If a work code has multiple owners, having types = B or A, then put YES in column D
• If work code has multiple owners but they belong to type = C, then it’s not an issue
Please see attached workbook