Hello
Looking for help to write a formula that will give me the result of column "C" below.
Tried this in my excel and obviously not working.... =IF(AND(COUNTIF((AH287="*team*", AJ287=1), "Yes", ""), (AH287="*team*"), AJ287=""), "Pending", ""))
I want it to return Yes if Team and a date, if Team and no date return Pending... everything else just blank.
Thanks in advance
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Looking for help to write a formula that will give me the result of column "C" below.
Tried this in my excel and obviously not working.... =IF(AND(COUNTIF((AH287="*team*", AJ287=1), "Yes", ""), (AH287="*team*"), AJ287=""), "Pending", ""))
I want it to return Yes if Team and a date, if Team and no date return Pending... everything else just blank.
Thanks in advance
A | B | C |
team | 23-Jan-19 | Yes |
single | ||
team | Pending | |
"this is empty cell" | ||
team | 23-Jan-19 | Yes |
single | ||
"this is empty cell" | ||
team | Pending | |
team | 23-Jan-19 | Yes |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col></colgroup><tbody>
</tbody>