Hi,

I have spreadsheet where I have following problem:

I need to fill is a column in a sheet with contacts. In this column I need to write the word “yes” or “no”. The data comes from different sheet within the same workbook. In this sheet the contacts are sorted by company. These companies have related contacts. These contacts are partners, Associates.n. The answer yes is correct if one of the related contacts is not in Frankfurt. If all related contacts have “Frankfurt” then the answer is “no”. So I have contacts with more than one associated firm contact. So I need a function to read out more than one row and give out a result from these.

Any questions just let me know