Hello,
Trying to found away to find next pattern or shift change using excel. please see below.
E-E-O-O-E
E-E-O-E-E
O-O-E-E-E
E-O-E-O-O
E-E-E-O-O
E-E-O-O-O
O-O-E-O-O
E-O-E-E-O
O-E-O-O-O
E-O-E-E-E
E-E-E-E-O
O-E-O-E-O
E-O-E-O-E
O-E-E-O-O
O-E-O-O-E
E-O-O-E-O
O-O-E-E-O
E-O-O-O-E
O-E-E-O-E
O-O-O-O-O...