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
[TABLE="width: 274"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]team[/TD]
[TD="align: right"]23-Jan-19[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]single[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]team[/TD]
[TD] [/TD]
[TD]Pending[/TD]
[/TR]
[TR]
[TD]"this is empty cell"[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]team[/TD]
[TD="align: right"]23-Jan-19[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]single[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]"this is empty cell"[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]team[/TD]
[TD] [/TD]
[TD]Pending[/TD]
[/TR]
[TR]
[TD]team[/TD]
[TD="align: right"]23-Jan-19[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 274"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 274"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]team[/TD]
[TD="align: right"]23-Jan-19[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]single[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]team[/TD]
[TD] [/TD]
[TD]Pending[/TD]
[/TR]
[TR]
[TD]"this is empty cell"[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]team[/TD]
[TD="align: right"]23-Jan-19[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]single[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]"this is empty cell"[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]team[/TD]
[TD] [/TD]
[TD]Pending[/TD]
[/TR]
[TR]
[TD]team[/TD]
[TD="align: right"]23-Jan-19[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 274"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]