Unanswered: check if cell has value in another column
I have table as below and I need to get column C. In A there is name of the firm, in Column B is a date. I need to know if for the firm A there is value in Column B, not just in appropriate row but in whole column.
Column A Column B Column C
A x Yes
A x YEs
B x Yes
C x Yes
I am trying to combine some ifs, but no success.
Thank you in advance!
Last edited by gvee; 12-08-14 at 06:57.
Reason: [code] tags for formatting