Count the number of times a text pattern is used

[pukks]

Hello Forum

I have a sample spreadsheet which I have simplified into two columns. I need to count the number of times a pattern occurs in column B.
So from row 2 to row 8 there is a pattern of text C040015,GAXXXX,JABC,JAFA,JALA,JALB,JALC - this repeats itself again row 9-15 and 16 - 22. (total 3 times)

rows 23 - 28 , 29 - 34 is another pattern C040015,GAXXXX,JABC,JAIA,JALA,JALC occurring twice

rows 35 - 42 , 43 - 50 another pattern JAAA,JAEA,JAFA,JAHC,JAHD,JALA,JALB,JALC occurring twice

so for this spreadsheet

pattern 1 occurs 3 times
pattern 1 occurs 2 times
pattern 1 occurs 2 times

You will note that the only time the pattern can change is when the number changes in column A

thanks
David