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