Hi
I have a column with 1,2,3,4 randomly throughout.
I am looking to mark the first occasion where I get any three of the four numbers...and then if the immediately following number matches any of the three unique numbers that have appeared (match)
If I get any three of the four numbers and the immediately following number is not a repeat, then I'd like to mark that too (no match)
So 1,2,3,3 would be an example of a match
But so would 3,2,1,1
And so would 4,4,3,3,3,2,4
And so would 4,1,4,1,2,1
I need to check only the first number immediately following the three unique results have appeared. So 4,1,1,4 wouldn't be checked, because only two unique numbers have appeared. 4,1,1,4,3,4 would be a match.
The number to check could appear in just 4 numbers but might not for 10 or even 20...hence difficulty in formulating.
4,3,2,1 would be a no match (three unique numbers and the fourth is also unique)
as would 4,1,4,1,2,3
These are distinct episodes - so once we know if we have a match or no match, we start tracking the numbers again.
Here's hoping...
Bookmarks