[Eden397]

I have 3 columns (Strain, Genealogy, MOComplete) Below is how I would like
the third column (MOComplete) to formulate. Genealogies are descending in
order and I have provided 3 examples of 3 different strains and 3 different
ways the genealogies can occur.

Some of my Strains have 2 different genealogies, some strains have 3
different genealogies, and some strains have 4 genealogies (Max).

The ordering of genealogies is always FS--PES--PED--POOL.

All POOL Genealogies must have an MOComplete=1.

If there are more than 2 genealogies, the genealogy following POOL will NOT
have an MOComplete but the genealogy that is 1 degree away from POOL needs to
have an MOComplete = 1 as does any remaining genealogy(ies).

Is this an If/Then statement? What is a good equation to get the MOComplete
for each strain and each genealogy? Thanks

Strain Genealogy MOComplete
49 FS
49 POOL 1

51 FS 1
51 PES
51 POOL 1

58 FS 1
58 PES 1
58 PED
58 POOL 1

[Mike H.]

Things I don't understand about your question:
1. You say pool is always at the bottom, but then you state that anything
following Pool will not have an MOComplete. How can it follow Pool if pool
is always at the bottom?
2. Also you use the word "degree" and I have no idea what you mean by
"degree"
3. I have no idea what equation would be a good one because I can't tell
what you need to calculate. If you can describe the calculation perhaps it
would help.
4. If you calculate by geneology, then I assume it is across all strains?
right? Please be MUCH more specific and I hope to be able to help you.

"Eden397" wrote:

I have 3 columns (Strain, Genealogy, MOComplete) Below is how I would like
the third column (MOComplete) to formulate. Genealogies are descending in
order and I have provided 3 examples of 3 different strains and 3 different
ways the genealogies can occur.

Some of my Strains have 2 different genealogies, some strains have 3
different genealogies, and some strains have 4 genealogies (Max).

The ordering of genealogies is always FS--PES--PED--POOL.

All POOL Genealogies must have an MOComplete=1.

If there are more than 2 genealogies, the genealogy following POOL will NOT
have an MOComplete but the genealogy that is 1 degree away from POOL needs to
have an MOComplete = 1 as does any remaining genealogy(ies).

Is this an If/Then statement? What is a good equation to get the MOComplete
for each strain and each genealogy? Thanks

Strain Genealogy MOComplete
49 FS
49 POOL 1

51 FS 1
51 PES
51 POOL 1

58 FS 1
58 PES 1
58 PED
58 POOL 1