Hi,
Hoping someone could help me with this problem below. I have recreated an excel sheet below. Column 1 is the color, Column 2 is the response (Yes/No), and column 3 is blank.
Is there a formula I can write in column 3 that will help me identify if, for a specific color, only "No" was selected on column B. For example - Blue is listed as "Yes" "Yes" "No" - so it would fail.
Red is listed as "No" and "No" - so, it would pass
Thanks!!!
<tbody>
</tbody>
Hoping someone could help me with this problem below. I have recreated an excel sheet below. Column 1 is the color, Column 2 is the response (Yes/No), and column 3 is blank.
Is there a formula I can write in column 3 that will help me identify if, for a specific color, only "No" was selected on column B. For example - Blue is listed as "Yes" "Yes" "No" - so it would fail.
Red is listed as "No" and "No" - so, it would pass
Thanks!!!
Column 1 | Column 2 | Column 3 |
Blue | Yes | |
Blue | Yes | |
Blue | No | Fail |
Red | No | |
Red | No | Pass |
<tbody>
</tbody>