Please advice,
I need to identify 4 different patterns in excel. I am not sure if it is possible using VBA, IF functions or something similar. Can somebody please guide me in the right direction?
I have tried to get help on another site, but have not received any answers yet.
See attached example.
The patterns can overlap each other and can be in any order. It would be nice if the different patterns can be highlighted in different colors. Once the 4 patterns have been identified the section closes and start all over again.
This is Baccarat score cards and I need to test several 1000. Each sheet has about 80 hands (inputs)
Currently I am doing it manually and as you can imagine it takes forever.
It also involves showing with win loss result and graph.
Data

4 Patterns identified from A2:H2

The 4 patterns

I need to identify 4 different patterns in excel. I am not sure if it is possible using VBA, IF functions or something similar. Can somebody please guide me in the right direction?
I have tried to get help on another site, but have not received any answers yet.
See attached example.
The patterns can overlap each other and can be in any order. It would be nice if the different patterns can be highlighted in different colors. Once the 4 patterns have been identified the section closes and start all over again.
This is Baccarat score cards and I need to test several 1000. Each sheet has about 80 hands (inputs)
Currently I am doing it manually and as you can imagine it takes forever.
It also involves showing with win loss result and graph.
Data

4 Patterns identified from A2:H2

The 4 patterns
