Hi Experts!
Long time since I begged for help on this forum, glad to be back
I've got a matrix combining actions on the left hand side (Col A) and owners on Cols B to F
I have drop down list for each action/owner combo: N/A, OK, KO, TBD.
Owner #1 Owner #2 Owner #3 Owner #4 Owner #5 Results Action #1 OK TBD N/A N/A N/A OK Action #2 TBD OK OK KO TBD KO Action #3
I would like to create a formula in Col G that does the following:
- If any of the values in columns B to F equals OK, then OK
- If any of the values in columns B to F equals KO, then KO
I've been tinkering with multiple IFs and quite rightly got bogged down as too many criteria to take into account...
Thanks in advance for your help and advice!
Bookmarks