Ok I wanted to know if I could get Excel to count an exact pattern, the data is in two separate columns as per the below.
I'd like to count the number of times a day is followed by the same day and the result is win followed by loss in the opposing column. As highlighted above.
So in the above example there would be 3.

I'd like to count the number of times a day is followed by the same day and the result is win followed by loss in the opposing column. As highlighted above.
So in the above example there would be 3.