Excel Function Query - How to filter with three criterias

[idlan]

Hi

I was wondering if anyone could point me in the general direction o
help with the following problem:

I have a list of companies, and each company has a board of directors
and each director has a position. I need to assign a unique code to th
director who performs a specific function in the firm (i.e. the CEO o
the Managing Director). Some firms have both positions, but other firm
only have a Managing Director, in which case he is effectively th
CEO.

At the moment, my system codes either a CEO or an MD with a '1'. In th
case of a firm that has both a CEO and an MD, I am only interested i
the CEO, but my system flags them both, thereby resulting in duplicate
data.

What I would like to do for every company (uniquely identifiable with
Company ID),is to see if the board of directors has a CEO and
Managing Director, and if so, to give a score of '1' for the CEO an
not to the Managing Director. If the company only has a CEO or only ha
a Managing Director, then a score of '1' is given to either that i
present.

Any ideas?

Thanks in advance
Idla

 

[Frank Kabel]

Hi
you may post some example rows of your data (plain text - no attachment
please) and describe your expected result based on this example data.
Probably using COUNTIF could work but please provide some data about
your spreadsheet layout