Hi,
I have following problem:
In the attached workbook I have a sheet where I need the answer "yes" or "no" in cell J based on the information in cell I. "Yes" if one of the cells in I does not have Frankfurt in it. The question is if a firm contact is known in another office than Frankfurt. The formula should read the information in cell I and put "yes" in cell J if one of the cells does not have "Frankfurt" in it. Please ask if you have any questions.
Thanks
Here the copy of the sheet:
cell I cell H
<colgroup><col><col></colgroup><tbody>
</tbody>
I have following problem:
In the attached workbook I have a sheet where I need the answer "yes" or "no" in cell J based on the information in cell I. "Yes" if one of the cells in I does not have Frankfurt in it. The question is if a firm contact is known in another office than Frankfurt. The formula should read the information in cell I and put "yes" in cell J if one of the cells does not have "Frankfurt" in it. Please ask if you have any questions.
Thanks
Here the copy of the sheet:
cell I cell H
Related Contacts Mailing Address State/Province | Firm Contact (known by offices other than Frankfurt) |
Frankfurt | |
Frankfurt | |
(blank) | |
Frankfurt |
<colgroup><col><col></colgroup><tbody>
</tbody>