Hi everyone, I've been scratching my head with this all day. I can think of solutions that apply to individual cases, but not something dynamic enough to adapt to different data. Essentially, I have a dataset that includes changes made to a policy. I'm looking to identify those that alternate between two names regularly. The problem is, the number of changes and the permutations of these can be flexible. For example, I'd want to include these policies, as their names at some point alternate between two: 1 2 3 4 5 6 7 Jones Jones Smith Jones Smith Jones Heath Davis Heath Davis Wallis King Wallis King Wallis Wallis King Matthews Matthews Matthews Stewart Matthews Stewart Matthews I wouldn't want to include these (below) as they do not regularly alternate: 1 2 3 4 5 6 7 Jones Jones Jones David David David David Smith Lucas Lucas Lucas Lucas Lucas Williams Williams Williams Williams Jones I'm not sure I've explained this particularly well, but I hope this makes sense. I'm trying to identify those that at any point exhibit a pattern of alternating between two names. I've been given the threshold of switching from one name to another and back again at any point in the history of changes. Thanks in advance for reading and for any advice.
... View more