Hi,
I was wondering if someone can help me with this. In column C I would put the formula for each row.
I wanted to look up if the value in Column A for value "CA" had any blank values in Column B then it would return "Yes". Also if column A for value "BA" has no blank values in column B it would return "No".
Column A Column B Column C
CA 1/1/2014 Yes
CA 2/2/2014 Yes
CA 4/2/2014 Yes
CA Yes
CA Yes
BA 2/2/2014 No
BA 3/3/2014 No
BA 1/1/2013 No
BA 2/2/2012 No
I was wondering if someone can help me with this. In column C I would put the formula for each row.
I wanted to look up if the value in Column A for value "CA" had any blank values in Column B then it would return "Yes". Also if column A for value "BA" has no blank values in column B it would return "No".
Column A Column B Column C
CA 1/1/2014 Yes
CA 2/2/2014 Yes
CA 4/2/2014 Yes
CA Yes
CA Yes
BA 2/2/2014 No
BA 3/3/2014 No
BA 1/1/2013 No
BA 2/2/2012 No