E
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
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